Lookup or Related Field

[Steve Kelep]

I'm having problems getting data from one db to another.

I have an external db with one record that generates a unique code (tri-alpha) 17,576 possibilites.

When the user clicks the confirm button in the main file, it runs an external script to increment a counter once.

I want the resulting code to be reflected in the main file - it doesn't work.

I have set up a relationship with a key field, that seems ok - the confirm button runs the external script, then setfield code::externalcode.

returns no data.

What am I doing wrong.

If the explanation is a bit hazy I can elaborate.

[Reed]

Can you post the file, and explain the actions necessary to reproduce the problem? That might help to understand...

[Steve Kelep]

Whoops! sorry, operator error!!

I forgot that I needed matching data in the key field for the lookup to work.

Thanx anyway.