Solved: relationship/validation

[rsilberfarb]

I have a database that automatically imports (via transfer spreadsheet macro) an excel file. They way I have it set up, if a ceretain value is not in a realted table, it does not import that record. This is half of what I want, what I would really like to happen, is that if the value is not in the related table, that it imports to a different table.

Please help

Ross

[Norie]

Why not just import all the records then use append queries to add to the appropriate tables?

[rsilberfarb]

I will try that.

[rsilberfarb]

that worked, thanks