Xataface Forums

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.

You would create a relationship. Then if you wanted it on the input form, you could use the grid widget.

-Steve