Related or unique shopping cart

Basically it’s the same idea as above, but for each “Cart item” you would have the “Business rowID” in there as well.

In your User Profiles table, create a relation to check for un-submitted rows, and return the business rowID (a single value column).

If the user is trying to add an item with a business ID different from their “currently added business ID” as described above, then you don’t allow them to add.

1 Like