Search results

  1. A

    Primary Keys

    I have a table for a multiple parents linked to a child table. I need to figure out a way to only allow 1 parent to be coded as primary, 1 as secondary, and then the rest as other... I thought about making Primary/Secondary/Other a primary key. But then I can only have 1 other. I would have...
  2. A

    Delete in table from input box

    I'm having trouble executing a SQL command in VB... I want it to find the the value of the input box in TBL-Purchases and Delete all related values. Here's my code.... I get an error on the line I've highlighted in green... Any thoughts? Private Sub Command31_Click() Dim Message...
  3. A

    Count Distinct

    I'm stuck... I have 2 tables linked with a 1 to many relationship by NAME. Tables look like this.... TBL-STORE NAME ADDRESS Walmart 12 Nowhere Target 14 Somewhere Lowes 10 Anywhere Sears 16 Nowhere TBL-PURCHASES NAME [NUMBER OF ITEMS] [PURCHASE DATE]...
Back
Top Bottom