Hi all this is my first post. Just been doing databases for about a month so i'm still pretty useless. I'm trying to set up a database for tracking incoming materials but i'm pretty sure i've made a mess of the tables. Could anyone have a look at the tables below and suggest the correct way to do it and also how to properly set up the relationships.
The tables 'Tbl_Suppliers' and 'Tbl_RawMaterials' have lists of the various suppliers and materials which are used by 2 combo boxes in Tbl_MainRecords to make a selection