Re: Will I need a junction table in this scenerio?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Markmarko,
looks the query for the form needs some changes
Post the SQL you are using.

Jeanette Cunningham


"markmarko" <markmarko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D176AA11-AD48-45CE-B53A-42665B9681BF@xxxxxxxxxxxxxxxx
Ok, so I'm implementing a junction table for this scenario. I think it
would
work now without doing so, but there may come some reason in the future
where
we'd like the versatility.

Now I'm experiencing a new problem. All my orders with 2 sales reps appear
twice in the form's query results. To explain, as I scroll through the
orders
I see order 123, then click next expecting to see order 124, but I see 123
again. It seems clear it's doing it since there are 2 reps on this order,
but
I don't know how to keep that from happening.

Incidentally, I'm using a subform for entering the 2 reps. Is that kosher?


.

Relevant Pages

  • Re: Format issue ... 2 decimal places displayed?
    ... Jeanette Cunningham wrote: ... to get sql of your query, open the query in design view, then select Query | SQL view from the menu. ... you applied the format to the combo box. ...
    (microsoft.public.access.forms)
  • Re: Combo Box and Is Null
    ... Dim strSQL As String ... 'the above line allows you to check that the query will ... "Jeanette Cunningham" wrote: ... If you post the SQL of the query you are using we will be able to help. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Somewhat novice Access user, tripped up in a query problem
    ... I am using Access, which has three MS Excel Linked tables, to store ... call center metrics for reps. ... I have a query that performs some ... Here is the SQL ...
    (comp.databases.ms-access)
  • Re: Combo Box and Is Null
    ... "Jeanette Cunningham" wrote: ... If you post the SQL of the query you are using we will be able to help. ... One point - your use of IsNull is not correct, but when we can see the SQL ... Null in the query criteria this works fine also. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Boolean in Query
    ... Switch the query to SQL view. ... Jeanette Cunningham ... data type. ...
    (microsoft.public.access.queries)