problems with related fields... :(

[silhougal]

hi all,

i have 3 separate db's, let's say A is Clients db, B is Consulants db & C is XMas cards db. there's a field in both A & B so that if i put a tick in this field, a record would be generated in C using data from A OR B, data should include several fields from A & B.

Does anyone have any clue on how i could tackle this efficiently?

cheers

[jasonwood]

Any reason why you can't use a button to activate a script?

The script could tick the checkbox if that's what you're worried about.

The script would copy the client number or consultant number, then run an external script in XMas Cards called "New card from clients" or "New card from consultants" which would create the new record and lookup the necessary information.

[silhougal]

thanks Jason, i think your solution would be good if i only have to insert the records in the XMas db once, problem is data such as address fields need to be updated automatically if their parent fields in A & B get changed. i am actually thinking of having calculated fields in XMas db, i can't think of anything yet though cheers....

[BobWeaver]

I've attached a simple example that shows a way to do what you want. Note that in the clients file, the XmasCard check box has been formatted as a button that performs a script to create or delete related records. A reverse relationship in the Xmas file displays current information directly from the Client file so that if Client information changes, it is immediately updated in the Xmas file.

createRelated.zip

[silhougal]

Thank you Bob, it does everything i want like you said.... gotta think of a harder scenario for you now cheers