Jump to content

adding tables to already created DB


Nemo
 Share

This topic is 5656 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

This topic is 5656 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.