Assume I have a many-to-many relationship between table A and table B that is implemented using a linking table L.
1) The linking table must have a primary key that consists of two columns. Can I define a multi-column primary key in Base? If not, can I create the linking table using DDL and create a muli-column primary key?
2) Is it possible to display the one-to-many relationship from table A to table B in a form? I can't see how to include the one-to-many link from A to L and the one-to-one link from L to B in a form since forms only support one level of sub-form.
Thanks.