Dependent fields with automatic filling in form (1 Viewer)

Thanks mr JHB for yor reply i found another way to feed the data.

Then another one problem how to prevent duplicate data entry without index (no duplicates) method. Is any other way

Mark_ said:

Senthil94,
Do you have 150 fields in your table?
Do you have 150 records in your table?

Click to expand...

I have more than 200 fields and i tried to prevent the wrong entries using combo boxes that depent on the previous cell show sugesstions. That sugesstion type is same in that creteria only deffers.access does not allow that much of index and combo box in data base