AppGini Community Forums

I get a circular reference error and it tells me to create a third table. Lost on this??

I have a table called units and one called tenants.

If I browse tenants I want to see what unit they are in and if I browse units I want to see which tenant is in that unit. How can I do this with a third table?

Create a third table, say, "occupations"
Look up in that table the "tenant" information and the "unit" information from their respective tables
This will create a record in "occupations" that contains both the tenant and the unit information.
You can then add further information relevant to "occupation" if you so wish to that third table.

Need to use a many-to-many relationship. Can't recreate a db-scheme like this:



I always got an error:

Error checking:
Field 'tblOrderDetails.OrderID' cannot be a primary key and a foreign key at the same time.

How can i create a scheme like in the picture above? The OrderID-Field and all other relations must be autofilled with existing table contents.

Use a separate primary key field, named for example "id" and set it to auto-increment .. you could also hide it from table view and detail view if you wish. After generating and uploading the application and setting it up, use phpMyAdmin to create a unique key on both "OrderId" and "ProductId" fields.