yes that is exactly what i have right now however the extra field makes it a bit tricky, i do not know how i will execute it. so you think this is the best way to do it?
the way im thinking of your advise id that i can easily have a combo box with the options listed and you can click away or...
yes that is exactly what i want except, say i add john smith to my DB with his full address, city etc however he is a supplier and i want to add him as a supplier, i will want his data to be assosiated via PK to the suppliers table, not customers and not employee table, then next, say i want to...
Hi i am a beginner at access, fairly new, understand some of the basics. i have a standard database with tblProducts, order, employees, customers, suppliers etc. i also have a table called tblperson with personID which acts as a one, with the many in three different tables (customers, suppliers...
I am new to this website/forum and also fairly new to access, some of these qestions and answers have really helped me with learning the basics, thanks guys!