Lookup related field based

[budgy]

I have a file with 2 tables and have managed to select all the data from all the "Sample No." field in Table 1 and list them as a lookup in the "Sample No. " fields in Table 2 via a self lookup and concatenate function as suggested by CyborgSam which worked very well.

I have 2 tables:

Table 1

"Sample No. 1"

"Sample 1 Details"

"Sample No. 2"

"Sample 2 Details"

etc to 10 sets

Table 2

"Sample No. 1" - value list based on the concatenation of the values in the Sample No. fields in table 1.

"Sample 1 Details"

"Sample No. 2"

"Sample 2 Details"

etc to 4 sets

Say the value in "Sample No.3" in Table 2 is from the "Sample No.1" field of Table 1

The lookup of "Sample 3 Details"in Table 2 needs to be the value in "Sample 1 details" from Table 2

Any ideas? I guess that I will have to use a script and button to activate the script to go to table 1 lookup the values then drop into the correct table 2 fields. Not too hot on writing script so any help would be appreciated

Thanks

FileMaker Version: 7

Platform: Windows 2000