help

[MarioPetrov]

I'm creating a customer database, some of my information is from this table. Does anyone have an idea how to create the table? Or is there a suggestion for a similar organization of all the necessary fields in the table?

[Tijesuni]

You can structure your table with the following fields:

ID Type Eye Sph Cyl Axis Pr Base Add PD

1	Distance	O.D.
2	Distance	O.S.
3	Near	O.D.
4	Near	O.S.

Explanation of Columns

• ID: A unique identifier for each row.

• Type: Distance (Далечина) or Near (Близина).

• Eye: Right eye (O.D.) or Left eye (O.S.).

• Sph (Sphere): Lens power.

• Cyl (Cylinder): Astigmatism correction.

• Axis: Angle for astigmatism correction.

• Pr (Prism): Prism correction (if needed).

• Base: Prism base direction.

• Add: Addition for bifocal/progressive lenses.

• PD (Pupillary Distance): Distance between pupils.