Started 2 years ago by kevgais | 2 posts |
Hi there,
Great product.
I'm connecting an access DB to the MySQl db to run some queries etc...
Is there any way I can deciphering what the field names are automatically? I notice that there are desciptions in the elements tables but I have no idea how to marry them up to the fields in "ap_form_#".
Ideally I'd just like a table in MS Access that has the correct named headings and refreshes with data on demand.
any ideas chaps?
You need to do a "JOIN" query to be able resolve those field names.
Basically each field has its own id number.
So let say you have a field "element_2", then you need to look into table "ap_form_elements". There you will see the actual field name by looking up the id number.
Here is an example of JOIN query:
http://www.appnitro.com/forums/topic/drop-downs-and-mysql?replies=11#post-1331
MachForm Founder
You must log in to post.
