is this possible?? I know that filemaker is odbc compatible, but Im not sure how to do relational database exports and things like that with odbc and vb using filemaker files.

My main database is on a one to many relationship with 6 other files, which all in turn have expansion tables. If anyone can help me or point me to some examples of using relational dbases from filemaker in vb, thanks in advance.

I do know that you can easily query FM with VB code to get values out of databases. You can also trigger scripts within FM through VB code. However, if you ever want to set values in FM through VB then you're screwed unless you like writing 200-page INSERT SQL commands (FM ODBC support sucks!). Here are two links that have *some* info on VB/ODBC/FileMaker.

www.filemaker.dk/support/tips/jlw99.pdf

www.kipwmi.com/fm/tips/doscript.htm

Also search the Microsoft Knowledge Base for FileMaker and you should find one article regarding connecting to FM.

I've been letting everyone I know not to ever waste money on FM support by asking them questions regarding VB and FileMaker. All support techs just blame Microsoft for all of FM's ODBC problems and close your support cases. Someday they may create useful ODBC drivers...