I am very new to Access. I have 2 tables. In the first I have Furniture items in the other I have the rooms that need the item(s). I would like to, use a form that will allow me to enter an item in the Furniture table and use that item to populate multiple rooms. For an example I have a Chair in the furniture Table ( this contain make model size color vendor...) I would like to tell the other "table Rooms" (containing type, function, assigned owner...) That the specific chair is in Room 1,2,3,4,5. Thanks.. I am a new.
I have tried it with a look up field where I can add multiple items. I can see the items listed in a field. Do I need to creat a new table to update so the records reflect room and item? I would do this via a query?