Search results

Thanks for that - you are a star! That seems to have sorted out the mail merge problem. What type of combo box would you recommend for the form design and what way should I set it up? My only concern would be not to create the same problem when entering data in the forms. Thanks again for your...

Hi - sorry was called away yesterday. Do you mind if I clarify this? I have for example Order Details Table with Customer id , Date, Product id, Quantity. I then have Products Table with Product id, Description and Price. Obviously have Customer table with name adress etc. as well. Currently my...

Sorry Rabbie - I realise that - was just joking to cover up my ignorance! Anyway - could someone answer re look up tables, how you set them up etc? Many thanks

Sorry about that - it was taking sooo long to load the reply that I hit the back button and started again - last reply put all three in! (Just take comfort from the fact that it's people like me who keep you in a job!!!) :D

Thanks! But as I'm bit of novice could you explain how look up table works? For example, one of the fields is 'Item Description' which I was looking up from 'Products' table. What info do I need in each look up table and how do I use it?

Hi - sorry this is really basic. One of the tables in my db has 3 look up fields. These display as I want them to in the table, but if I use the fields in Mail Merge they appear as ID numbers. How do I fix this?:confused:

Hi - sorry this is so basic. One of my tables has 3 look up fields. These appear as ID numbers in Mail Merge. I use this table as a base for most of my queries and they are same. It is obviously something to do with the look ups as the data in the non look up fields is ok. Anybody point me in...