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
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
Mr .JHB i stuked up .ihave to create more than 150 combo box entries it is not allowing to save access file. So please help.is there any work around for that
Dear mr .JHBthank you for your solution but in that i got idea to how to dependency.
Another help
In querry how we can get datas from 2 different table in that machine sl no is same.
But the problem is i have to get 2machine sl no details in a single row.
Another one
is it possible to protect...
Thanks mr.JHB but i have an issue in your shared access data base u wrongly taken the sample.
That machine model part description should be in other table. It should fill to another table through form in that form i have to select based on first table.and it have to fill another fields...
Sorry for in convenience. Im asking if i have 5 different type of machines and each have 4models that models having various individual parts.it is master data base
Then during despatch or any other application im creating one form .
inthat form containg datas like
1. Machine type
2.model...
Hi all im very new to Microsoft access .im intrested its features. So i want some help for following .
My data base
Equipment model part. description drawing no
Crusher. X125. X125001. Xyz. 1234.
X125002...