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.