We've been using Xataface for a few months now for the backend of maintenance calendar, and it is working great. The main form has data that looks something like this:
event_id, //unique identifier
start_date,
end_date,
description,
tech_contact,
field_contact
And there's another table that has field_contact's and tech_contacts:
contact_id,
contact_name,
contact_email_addr
Now, my co-workers don't want to be tied to just one field and tech contact per event. Plus, they don't even care what kind of contact they are. I could do this:
event_id, //unique identifier
start_date,
end_date,
description,
contact_1,
contact_2,
...
contact_n
But that's really messy and not the right way to do it. According to the rules of db normalization, the right way to do this is to add an intermediate table to map event_id's to contact_id's.
relationship_id, //PK, not really used for anything.
event_id,
contact_id
But how do I show this relationship in xataface? What will this look like on the input form? Will I have to program a new control like a drop-down checkbox?
I hope my question makes sense.