Search results

Hi Gina/Simon, Reattached all required files. Thanks Friends, Really appreciate your efforts... Philip

Yes, after I made changes to the lookup table per your directions, I did not update the Bookings_Reservations form... I had deleted the exterior, interior and veneer separate tables to be replaced by 'vehicle colour' table. The model is to be replaced by variants. I will send you the updated 2...

Hi Simon/Gina, I've added vehModelID to the variants table to lock it down as suggested. However, I am not sure what you've meant "On the Interior Colour there is already the Variant." Plus, I am sorry but I could have saved you time there... I have now attached the form that I have made...

Hi Simon, I am not quiet sure if I follow that... I will give it a try now and update you soon. Thanks, Philip

Hi Gina, Thank you for your detailed guidance. Worked on your gist and drilled down the tables (See DB Attachment) Now the whole colour combinations depends first on the variant. Model table is not in use for this purpose. My current issue is how do I go about entering data into the colour...

Greetings, Kindly advise on this issue with tables. I will be as discrete as I possibly can in this regards... We are an automobiles organization based in Dubai. Our main Access DB contains links to a lookup DB(containing many tables). The main DB has 1 table & 1 form storing information...