How to get a table field to pull information from another table field.

[donnie.atchison]

I am stuck. I am building a database with a Master table and multiple other tables (Secondary Tables) that have the following fields, Shipment Number (Data type is Number), and the other fields have a data type of Yes/No. What I need to happen is in the Shipment Number Field I need the field to populate with the Shipment Number from the Master Table even if data is not entered into the secondary table. I would build the secondary fields Yes/No into the master table but I have about 1000 Yes no fields that I have to track in the database. Since tables are limited to 255 fields I cannot do this. What can I try.

[June7]

A normalized structure would have instead of 1000 Yes/No fields, a related table with 3 fields - ShipmentNumber, item identifier, and the Y/N response.

[kd2017]

Can you explain in more detail what it is your database is tracking/what your trying to achieve? We'll need more specifics to be able to help.

[isladogs]

I would build the secondary fields Yes/No into the master table but I have about 1000 Yes no fields that I have to track in the database. Since tables are limited to 255 fields I cannot do this. What can I try.

Sorry to say you need to redesign your database from scratch
It sounds like you have a spreadsheet on steroids with your 1000 Yes/No fields - lots of fields & relatively few records
That is not a database structure
Databases have few fields & lots of records

So your table might have these fields
ShipmentID - autonumber PK field
ShipmentNumber - number
CheckValue - yes/no
CheckType - text

So each shipment number might have 1000 records each with one yes/no field & another description filed that I've called CheckType

[donnie.atchison]

I rebuilt the data base and solved my problems thanks.