Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 06-12-2019, 03:05 AM   #1
Cark
Newly Registered User
 
Join Date: Dec 2016
Posts: 138
Thanks: 55
Thanked 1 Time in 1 Post
Cark is on a distinguished road
Advice needed on Table Layout and Relationships

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.
Attached Images
File Type: png Capture.PNG (45.0 KB, 22 views)
Attached Files
File Type: accdb TableLayout.accdb (1,004.0 KB, 20 views)

Cark is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice on Contacts and Telephone Table and Relationships??? hullstorage Tables 1 10-10-2011 06:47 PM
advice needed for table layout/design for a newbie jas118 Tables 8 06-05-2010 02:49 PM
Payroll database- advice needed on relationships/normalisation RCurtin Tables 13 08-12-2009 01:21 AM
Creating new layout for tables and need advice... SimonSezz Tables 2 02-05-2009 09:56 PM
Is a new table needed? Advice needed sueviolet Tables 4 09-11-2002 10:54 AM




All times are GMT -8. The time now is 08:08 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World