Scenario:

We have a single table database consisting of six fields,

Job name

Project Manager

Building Address

Job Number

Superintendent

Serial Number (self entering Serial Number)

We populated it with 3 records and then copied over a table from another single table database. These six same fields are in that table with the relational field being Serial.

The information however will not populate. If we go to the relationship and change its type to ‘X’ (match all) instead of ‘=’ it will populate with the first record, but we are unable to scroll through the related records. I know there is a discrepancy being the records do not match up. When you add an additional table to and already created database what must be done to “sync” them?

It's not clear what you're trying to accomplish. If you're adding a table to your database so that you can track a new entity, then there's no synching that needs to take place.

If, however, you're trying to get a bunch of data from another realm into your current database, what you need to do is import the data into the existing table.

Maybe you could provide more info on the scenario?

David

P.S. This probably belongs in another area of the forums...