Hi I'm new to this forum and to Access.
I have created a database for the storage of plates in freezers with 6 tables. Plates belong to a library ( eg plaate01, plate02 are part of library with the name Serie_A)
The plates are stored in a rack and there can be 10 plates in a rack ( so plate01 until plate10 in rack_01 and plates plate11 until plate20 in rack_02) and these racks are stored in a freezer .
There are 6 tables (T_Plate, T_Rack, T_Freezer, T_Rack_Plate, T_Freezer_Rack and T_Library)
If I create a select query for plates that are in a rack in a freezer the plates with platename, checkindate, rackname, freezername and libraryname are shown. But there are also plates that are not in a rack and not in a freezer but out on loan. And also these plates should show up if I run that select query.
I understand that it is difficult to answer if you dont see the relationships or the database an therefor these attachments
Can someone help me? Tried to attach zip file, but is too big. Is there an other way to attach zipfile