Hi

I want to generate a value list in one layout BASED on a found set from a different layout

I have two tables, each with a layout:

tblOperations [layoutOperations]

tblSurgeons [layoutSurgeons]

I want to generate a value list in layoutOperations BASED on a found set from tblSurgeons:Surgeon = "Mr"

any help would be greatly appreciated!

tim

tblSurgeons

surgeon___title

John______Mr

Sally______Professor

Andrew____Mr

Hi, my frend!

Create one script which in new window opens your tblSurgeons [layoutSurgeons], where before each record you will have "Use" button. After pressing this buuton you by script use wishing field and copy it to tblOperations. After all close opened window.

Will be better if you attach the part of your tables and we create example on your attachment.

Edited January 9, 200620 yr by Guest