HOW DO I USE RELATIONSHIPS IN ACCESS

G

Goldstar0011

I need to create a database for as follows.

Input, Screen 1 - Input off PO number, returns number, part number, date
received and other notes

Returns, Screen 2 - Input of Returns number, which in-turn will pull the
matching data from Input screen for me to complete return

The returns number is unique and can never be used more than once.

I haven't used Access in years so am very rusty!
 
J

John Vinson

I need to create a database for as follows.

Input, Screen 1 - Input off PO number, returns number, part number, date
received and other notes

Returns, Screen 2 - Input of Returns number, which in-turn will pull the
matching data from Input screen for me to complete return

The returns number is unique and can never be used more than once.

I haven't used Access in years so am very rusty!
Click to expand...

First off...

Access doesn't use "screens". It uses Forms. And, more importantly,
Forms are decidedly SECONDARY. The basis of your database is not the
forms, it's the Tables. You need to get your table structure correct
first, and *then* worry about using forms to edit and display the
table data.

So... what IS your table structure? I'd assume you would need at least
the following tables:

Parts
PartNumber
Description
<other info about the part as an entity>

PurchaseOrders
PONumber Primary Key
PODate
<other info about the PO as a whole>

PODetails
PONumber
PartNumber <assuming a PO might involve multiple Parts>
Price
<etc etc>

Returns
ReturnsNumber
PONumber <which PO is involved in the return>
PartNumber <which Part is being returned, you'll have multiple
records if multiple parts are returned, or you may need a
ReturnsDetails table to list all the parts in a return>
ReturnDate
ReturnReason

It sounds like you may be designing the forms first, which is not a
good idea; and that you're contemplating storing information (such as
the part description) redundantly. Don't!

John W. Vinson[MVP]
 
G

Goldstar0011

What I need as follows:

Table - UNITS RECEIVED - holding all data regarding units deivered
Date - auto input
PO number - manual input from delivery note supplied
Part number - again off delivery note
Notes - specific unit details

Form - RECEIVED - screen to allow input of data to the UNITS RECEIVED table

Form - RETURNS - Screen where I scan / input retuns number (as this is the
only unique number) which in turn will bring up the related data from UNITS
RECEIVED table. I can then add any further notes and add date I am returning
 
J

John Vinson

What I need as follows:

Table - UNITS RECEIVED - holding all data regarding units deivered
Date - auto input
PO number - manual input from delivery note supplied
Part number - again off delivery note
Notes - specific unit details

Form - RECEIVED - screen to allow input of data to the UNITS RECEIVED table

Form - RETURNS - Screen where I scan / input retuns number (as this is the
only unique number) which in turn will bring up the related data from UNITS
RECEIVED table. I can then add any further notes and add date I am returning
Click to expand...

Goldstar, it sounds like you want a complete Access application
developed. That goes way, way beyond the scope of free, peer to peer
volunteer service.

I don't understand the Returns. You say you enter the unique Returns
number, and it should pull up information from the UNITS RECEIVED. How
do you make the link? Is the Returns number already stored in one of
the other tables, or is it somehow linked to the UNITS RECEIVED table
in some other way?


John W. Vinson[MVP]
 
Top