Recent content by mikeaa101

Thanks, I figured it out about 2 minutes after posting Cheers Mike

Thanks, Having looked at the reply I can see why, I have no issue getting the data onto a form and have already done it however, the biggest problem for me at the moment is getting the data to total. For example if I enter a new order into my DB using the NewOrder form when I choose the...

Hi I am trying to get the following scenario to work I have a database containing 3 tables Billing Customers Components Each table is related I have a one to many relationship existing between Components and Billing and I use a lookup in my billing table to extract the field component ID...

Great thanks alot mate you have been a big help Mike

Ah ok this is becoming a bit clearer now I have just been looking online and found info about using a combo box in a form to call information would this work for me here do you think http://youtu.be/vuiKb8jeKTM Mike

Yes Products is components In reality of course an order can consist of more than one component in practice for what we are doing if it makes it easier then would say it is not vitally important. Thanks

Thanks for the reply This is very much a work in progress so there are going to be many mistakes along the way It will be a very small database and for a student assignment which is why I wish to keep everything as simple as possible. We are still in the design and test phase at present and...

I am creating a database with a student of mine it has been a very long time since I used access to any great degree and I am very very rusty. The database we are creating has 5 tables in it Customers Orders Products Billing Vat I am trying to create a form that will automatically create an...

Hi coming back to access after many years away and am going to plenty of help as all the things I learnt many years ago seem to have leaked out of my brain. Mike