Is this a relationship problem or a lookup problem?

[Karen1958]

I currently have 1 DB with multiple layouts.

1 of those layouts should be a separate DB, but I don't know how to achieve a lookup between the two if I separate them.

The way it currently works (and the way I'd like it to continue to work after I make them 2 separate DBs):

1) From my "Main" layout, I run a script that changes to the "Master" layout and runs a find script in a title/artist field.

2) From the records returned I choose one, then run a script which copies the contents of that field, switches back to the "Main" layout and pastes in a corresponding field.

3) The script continues by returning to the "Master" record I'd already chosen, copying the contents of another field, returning to the "Main" layout, and pasting the contents of the second field into a second corresponding one.

There is NO relationship between the layouts. Changing the contents of either field in either layout does not change the contents in the other. Deleting a record in one layout does not delete a record in the other (well, it DOES, obviously, but the way the record looks in the other layout from whichever one I'm deleting records is nothing but blank fields - an empty record completely...which is why I need to separate these, because it's getting ridiculous. In each layout there are now many [what look like] blank records).

I can establish a relationship between the fields in 2 separate DBs, but then can't seem to rewrite the script so it runs; and in any event DON'T WANT ANY CHANGES in these fields to affect the corresponding fields in the other DB.

A lookup doesn't work, either, because it compares values and the exact value will never be identical: in order to find the record I want, I'm entering as little information as possible, and then choosing the best match from which to create a new record in the "Main" layout.

How to do this?

[nylon]

It's a bit unclear what you're trying to achieve - trying to look up data in one field and copy it to another - different - field?

It sounds like there's a fundamental design flaw in your dB but from your description, it's hard to determine where it is.

I currently have 1 DB with multiple layouts.

1 of those layouts should be a separate DB, but I don't know how to achieve a lookup between the two if I separate them.

The way it currently works (and the way I'd like it to continue to work after I make them 2 separate DBs):

1) From my "Main" layout, I run a script that changes to the "Master" layout and runs a find script in a title/artist field.

2) From the records returned I choose one, then run a script which copies the contents of that field, switches back to the "Main" layout and pastes in a corresponding field.

3) The script continues by returning to the "Master" record I'd already chosen, copying the contents of another field, returning to the "Main" layout, and pasting the contents of the second field into a second corresponding one.

There is NO relationship between the layouts. Changing the contents of either field in either layout does not change the contents in the other. Deleting a record in one layout does not delete a record in the other (well, it DOES, obviously, but the way the record looks in the other layout from whichever one I'm deleting records is nothing but blank fields - an empty record completely...which is why I need to separate these, because it's getting ridiculous. In each layout there are now many [what look like] blank records).

I can establish a relationship between the fields in 2 separate DBs, but then can't seem to rewrite the script so it runs; and in any event DON'T WANT ANY CHANGES in these fields to affect the corresponding fields in the other DB.

A lookup doesn't work, either, because it compares values and the exact value will never be identical: in order to find the record I want, I'm entering as little information as possible, and then choosing the best match from which to create a new record in the "Main" layout.

How to do this?