Please HELP! Question about multiple tables/data integrity

G

Guest

I feel like a kid cheating on a test, but I'm desperate for help. I've got a
question from a job recruiter for a position I really want but I'm not sure
of how to proceed.

The question is-
"You've imported multiple files into a database. Table A contains GL data
and some of these records need to be replaced with data in Table B. How
would you replace the data in Table A with the data in Table B without a
unique identifier? How do you maintain data integrity?"

Am I on the right track with 'Creating Relationships Between Tables'? I
have taught myself to use Access over the years, but this doesn't quite
register with me. I have a potential job riding on answering the question
correctly (and of course being able to actually perform the actions that I
state.)

Any help or guidance will be appreciated more than you know!
 
G

Guest

Well, you need to determine a combination of fields that will identify a
specific record. Then I'd simply use an ADO query to replace the data.
 
G

Guest

Did the question not include the rules on which records in A should be
replaced?
Without that information, I think the question is unanswerable.
Even without a single unique indentifier, there has to be a combination of
fields with specific values to match the records.

Since the question states that A contains GL data, it would also have to
contain a GL Account number to match to.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top