Intergrating FM and SQL Data Structure

[nmm222]

So i am trying to integrate an FM database and an SQL database. We have an online database that stores our user infomation. We have a FM database that will keep some offline data, but mostly use it for queries and print layout for mailings. My issue is how to deal with the sql structure. The structure is as follows:

Each piece of data is stored in a table containing three fields: Each data pieces is a new record

UID (userid)

FID (identifies what the data is (last name, first name, address etc.)

Value (the actual data)

I am trying to get filemaker to search these records as if they were fields. I can display these in a portland but cannot get them to query individually. I could just dump the info into a new fm db each times, but that seems slow and I cant update the sql from fm

Any suggestions?

Thanks

Nicholas

[Ocean West]

Here is a tech breif that may help a little:

http://www.filemaker.com/downloads/pdf/public_techbrief_ess_en.pdf

[nmm222]

Thanks for the tech brief. Unfortunately it didnt help solve my problem. I can connect and access the sql database fine. The issue is the sql database structure and laying out in a useful manner.

[Colin Keefe]

Your data source is using an entity-attribute schema.

You might find this thread helpful:

http://www.fmforums.com/forum/showtopic.php?tid/193176/

[nmm222]

Thanks,

Exactly what i was looking for. Sometimes its hard to know exactly what to search for

NMM