I have a bit of a peculiar database and form that I am trying to create to store lots of different bits of information in one nice and holistic database. Each Tab has different bits of information that are submitted from around the business that all contribute to an analysis of a Part Number. In the future, I will end up wanting to be able to search for a Part Number and then be able to find out what Reliability, Engineering, Finance, Design, Sales and Aftercare all have to say with regards to Part "XXXXX".
I know I will need to collect the data fields I have added on my Form in a Table, but I don't have a clue how I would go about arranging my Tables and the Relationships to get this to work.
None of the data from the tabs will ever overlap and the only connection will be to the Part Number. Therefore will I need a table for the Part Numbers and then an individual table for each of "Reliability, Engineering, Finance, Design, Sales, Aftercare"?
The attached database has a form called OverViewForm where I am trying to convey how I hope the Form will look. The Text Boxes are not linked to tables yet. The Tables in the database are just my vague attempts at getting this to work and I don't think they will be much use in helping to assist me, therefore I would stick with looking at OverViewForm for an idea of what I am trying to achieve.
Let me know if any further details / diagrams / images are needed to get across what I am trying to achieve.