Inserting records into Multiple Tables at one with DataAssist is this possible
Hi I would like to insert and update, search, results and delete records from multiple tables in one form operation.
Basically I have 4 tables in mysql db.
1. Main Venue Listings
2. Meeting Rooms
3. Rates
4. Users - i.e. the inputter.
The relationship between db 1 and 3 and 4 is a one to one mapping and they have primary keys, like User id, Listing id and Rates id.
So if a user registers, they have a login, registration information and then fill out a listing and a rates forms. How do I get they to a 1 to 1 mapping between these three tables, so in admin I can see 1 user, and corresponding listing and rates records and create all this in DataAssist 2.0 please?
Secondly I need to setup another relationship, how do I do this in DataAssist 2.0?
I need 1 listings id which can a venue name to possible correspond to 1 to 40 Meetiing rooms id's (input with your multiple input, update and delete.
So the listing id and venue name from the listing table needs to be populated in the meeting rooms table on a 1 to many relationship.
How do I do this in DataAssist 2.0?
Thirdly, when you tell DataAssist 2.0 what form elements to use the default always seems to be text field. I have a lot of checkbox that are needed for the data elements. What should I change the data type to in mysql tables so that Data Assist automatically recognised the need for a checkbox. So far the intend checkbox fields are INT types.
Thank you for all your help,
Neil
