structure field name

[yogi]

I have 2 tables.
1 tables cointains field_name

2 tables contains data


I want to create a query that I could use the field_name from table 1 (loop thru table1 )to see if the field_name exist in table 2

thanks

 

[gemma-the-husky]

not query but in code

fldexists = len(currentdb.tabledefs("targettable").fields("targetfield").name)>0

however this test will fail if the field doesnt exists, so you need to trap the failure

 

[yogi]

i could used this code to go thru a table or loop thru every fields.