Xataface Forums

Hi Again, Sorry..I seem to be taking up a lot of time on this board

I've created what I think is a many-many relationship...but something is still not working properly (there's a surprise).

I have two normal tables "SiteData" and "ContractData" and a thrid table (to handle the relationship) called "SiteData_ContractData"

In ContractData I want to be able to create a new contract and have a list of Sites made available (pulled from SiteData) that could be a member of that contract. I've created a relationship so that the Sites appear with checkboxes next to them (great). I can select any number of them and create the contract. All is well.

However....

If I create another contract I'm unable to re-use those Sites I used previously...and I really need to be able to allow Sites to be members of multiple contracts (It actually says they've been successfully added - but they really haven't). I did have a weird issue at one point of this feature creating duplicate Sites in "SiteData" but it's stopped now (which is good) (possibly because I messed with the UNIQUE key).

tables/ContractData/fields.ini

Code: Select all

[SiteName]
widget:label = "Site Name"
widget:question = "Select one or multiple sites for this contract"
transient=1
relationship=SiteData
widget:type=checkbox
widget:columns=5
validators:required = true


tables/ContractData/relationships.ini

Code: Select all

[SiteData]
SiteData_ContractData.ContractRecordID="$ContractRecordID"
SiteData_ContractData.SiteName=SiteData.SiteName


Have I messed something up that you can see?

Thanks again.

Paul

All sorted - Composite key issue (checked with a DBA at work )

Cheers