Hi, I am new to this, and fairly new to FileMaker. I am using FM Pro 7 and am haveing trouble importing a database with multiple tables that are related. When I import, it is ONLY importing one table. In the docs it says to have the layout you want imported (the other table in this case) selected when you want to import that other table. All of this is coming from the exact same database, except it is a clone of the main database (used for data entry purposes, no chance of messing up the main database - data integrity). If anyone could shred some light on this that would be teriffic.

Thanks,

Nick

Does anybody know how to import a multiple related table database into another? (e.g. from a clone of the database to the main database?) please help! thank you!

nbl

NBL -

Am I missing something here? Are you trying to import records from FileA into a clone of FileA? Why not just save a copy of the file instead? Not sure what your end goal is in all this.

SR

SR,

Data entry is not complete in one sitting. so say you enter in 100 records a day. After day 1, you have 100 records, day 2, 200, et cetera. I do not want the data entry person touching the main database or seeing previous records. Hence, by always entering into a clone, you are keeping it separate, and when you clean the data, it is just that new set of records. Once that is all fine and dandy, you import the cleaned set of records into the main database.

Go to Layout [associated with table1]

Import Records [No dialog; FileName.fp7; Add]

Go to Layout [associated with table2]

Import Records [No dialog; FileName.fp7; Add]

Go to Layout [associated with table3]

Import Records [No dialog; FileName.fp7; Add]

etc.

Nick, i do not know the answer to your question. I am replying here because:

(A) it is poor form to send private messages to someone who is not part of a thread and has not invited such messages and

(: it is just obnoxious to block incoming messages so that i cannot reply.

Jerry

Forgot i had it blocked, and if you do not want to answer or help me, that is okay. i am not making you give me an answer. its like finding someone's email address and mailing them. sorry if i have inconvenienced you.

nbl

No problem. We're here to help, it's just that's not part of the etiquette. (Nor is "finding someone's email address and mailing them"... that's spam!)