Hi All.
I try to create Inventory database where some group of devices can locatated in the same room. I created three tables: Table1, Table2 and Table3.
Fields of Table1 are: Tab1ID, Device, SN and more.
Fields of Table2 are:Table2ID, Table1ID, Location, Room.
Fields of Table3 are: Table3ID, Table1ID, HowTook, Date.
What is correct way to link tables or I need to create other Table4 which will keep ID's fields: Table1ID and Table2ID?
My Main form based on Table1. The subform I want to create using Table2 or query with Table1, Table2 or if need Table4.
My problem is crete a form using Table1 and Table2?
I try to create Inventory database where some group of devices can locatated in the same room. I created three tables: Table1, Table2 and Table3.
Fields of Table1 are: Tab1ID, Device, SN and more.
Fields of Table2 are:Table2ID, Table1ID, Location, Room.
Fields of Table3 are: Table3ID, Table1ID, HowTook, Date.
What is correct way to link tables or I need to create other Table4 which will keep ID's fields: Table1ID and Table2ID?
My Main form based on Table1. The subform I want to create using Table2 or query with Table1, Table2 or if need Table4.
My problem is crete a form using Table1 and Table2?
