Thanks Hammer, sorry for not being specific, I'm still trying to learn Sesame and how it works and terminology.
In my SQL example I used one table because thats what I would want to have ideally but I have 5 tables/databases in this application in Sesame. In Access these tables would be joined on common columns and I would use those to retieve the complete record from the 5 tables, but in Sesame I can't figure on how to do that but its like you said, maybe its because its not SQL based or a true relational database engine(which makes me curious on exactly how the seperate elements in the 5 databases I have are part of one complete 'record' and how they know where to point to one another?) .
I will talk to the creater of the application and find out how he created the file as far as the linking goes because I think thats the key problem here. Maybe a redesign or mod to the design is needed in order to accomplish what I'm trying to do.
Thanks again for all your help.

BOBSCOTT Wrote:
"One basic method you can use to get all data per record together is by creating a form with each of the remaining databases as subforms. The elements on the main form are then available to export and by creating variables and using  @formfieldValue() you can then have all the related data available to export. "

I have tried this but still I can't see the elements on the subforms? I added a new database and new form under that database and then added 2 subforms which were forms from 2 other databases in the same application. But when I open it up in runtime and do an F10, no data shows up in the subforms that are on the new form I just created.

I have tried using both types of linking. When I do a search now I still get no data showing on the forms but I placed a command button on the form and wrote code behind it(@xLookupSourceListAll) and when I do that I can at least retrieve data from the form specified in the function parameters but I need to retieve data from all the subforms, not just one subform at a time. I guess thats where the linking comes in. Any suggestions about where to look in the manual regarding my linking problem?

Maybe I'm wrong but I've been thinking about this and the only way I can traverse through the complete records 1 at a time is by using the @FormFieldValue function with all the field values being on one form.
Am I wrong?
Thanks once again.

Quote:


A Lantican may be able to give you a simpler or better method.

The method I have used was to export my data and then import it into my revised database. Look in the users guide starting at page 342 Importing Data. If i understood what you are trying to do, this should help.