Search results

Again...my brain is trying to over complicate unnecessarily. Thanks Paul

Hi Leigh, I forgot to thank you but your advice worked, and what I was trying to achieve wasn't feasible. I have now created it so that on allocating a client to an order,I allocate a card to them and then select which card the order is for based on cards allocated to that client. So... thank...

Hi Leigh, I have changed the tables and relationships but I'm now have another dilema. My tables now look like this... CLIENT --> CARDS --> ORDERCARDS -> ORDER client_id.....card_no.....cardlist_id.........order_ref ...................client_id......card_no...

Hi Leigh, As you can probably guess I'm a bit of a newbie to this world and these 3 tables are part of a much larger db. I was toying around with having the cards linked directly to the client (client table) but my issue was... A client can make many orders(sales) An order can have multiple...

Thanks for the reply, thats been really helpful although I'm not there yet. It sort of works... after creating an entry on the ORDERCARDS subform, i receive a "Duplicate Primary Key entery error message" (I won't type that out in full) forcing me to exit the mainform (where I then receive the...

Hi guys, I have the following 3 tables & associated keys... ORDER -> ORDERCARDS -> CARDS order_id.....order_id...........card_no client_id......card_no I have a main form based on ORDER and the subform being the ORDERCARDS, which has a combo box to either select an existing card_no...

The SQL statement is this... SELECT CP_CARDS.CARD_NO FROM (CLIENT INNER JOIN CP_ORDER ON CLIENT.CLIENT_ID = CP_ORDER.CLIENT_ID) INNER JOIN (CP_CARDS INNER JOIN CP_ORDERCARDS ON CP_CARDS.CARD_NO = CP_ORDERCARDS.CARD_NO) ON CP_ORDER.ORDER_REF = CP_ORDERCARDS.ORDER_REF WHERE...

Hi Rx, As per my previous post... yes it worked but in the process destroyed a not-in-list event that I have for the combo box to work. What happens now is that when you click on the combo box - it now only brings up previous cards issued to that person, but on typing a new card (not...

Hi Rx. You are a star - thank you. Paul

Hi guys, I have designed a client database which works, but am stuck on one area involving a combo box on a subform and its relation to the record displayed on the main form. I believe this may involve VBA as I cant imagine a standard SQL script doing what I need. There are 4 tables...

Sorry... the "left allignment" after posting has messed up my tables described above, therefore... CLIENT Table client_id ORDER Table order_id client_id CARDORDER table order_id card# CARDS card# Cheers

Hi guys, You will have to forgive my access ignorance, but I am what the kids call a noob to access & the world of database design (inc VBA, Macros etc) - so I do apologise in advance if the answer lies within these forum walls or if I'm posting in the wrong place. I have designed a client...