Interview Question in Database Design
Interview Question :: Creating forms in MS Access
I am creating a database for vendors and their services. I have three tables, VendorID with vendor info and an ID number as a primary key. I have ServiceID with the services I am using an ID number for each of the services. Then I have an intersection table linking each vendor ID with the service ID's of the services they offer (some offer more then one service), so it is a one to many relationship where I have the vendorID from vendorID table linked to the vendorID of the intersection table and serviceID on the intersection table to the serviceID on the serviceID table. I need one or more forms that will let me add vendors and possibly add new services too. I do not know SQL, I prefer wizard mode, but I can use design mode if needed. Any help?
Loading ...