Relationships Help Please

[alarm_guy1]

Hi guys,

Many many years ago i dabbled with a access and created a little database that had customer Table and Form and a customer order form.

I seem to have forgotten a lot of what I picked up back then, I'm just starting a database for my mate who runs a cake business.

I want it to be quite simple, my 2 hurdles are
1, I want to have a form that has an ID field of 6 characters, when I type in a 6 character id I want it to populate various fields that contain relevant data from that customer. i.e. first name surname address etc, I just cant quite get there.

2, Once completed I would like a button that when clicked asks you for a month and you input a month i.e. dec.
then all clients that have an anniversary, birthday or other event in Dec will be displayed and then we could email each client with specific offers or reminders.

I know that the customer ID needs to be unique and I need a one to many relationship,

but have tried several times but cannot make it happen.

any help greatly appreciated



Keith

[June7]

If you have only one table then your data structure is probably not normalized. If you expect repeat customers then you need a table of customers and table of orders (maybe another table for order details and maybe a table of products). Use form/subform arrangement. Main form bound to customers and subform bound to Orders. Go to an existing customer, or add new customer, on the main form and enter their order info in subform.

Or

Have main form bound to Orders and select customer in combobox, subform bound to OrderDetails. Enter products ordered in subform.

1. An autonumber type field can accommodate generation of unique ID. Here is one way to filter form: http://datapigtechnologies.com/flash...tomfilter.html

2. You have a lot to learn before tackling something this advanced. Review: https://www.accessforums.net/access/...ils-36702.html

[alarm_guy1]

Thankyou for the prompt reply, I have now managed to sort out the first problem thankyou, now I just have to plough through setting everything as required.

The 2nd problem is a way off yet but at least i have been pointed in the right direction for when i'm ready.

once again many tanks

Keith

If you have only one table then your data structure is probably not normalized. If you expect repeat customers then you need a table of customers and table of orders (maybe another table for order details and maybe a table of products). Use form/subform arrangement. Main form bound to customers and subform bound to Orders. Go to an existing customer, or add new customer, on the main form and enter their order info in subform.

Or

Have main form bound to Orders and select customer in combobox, subform bound to OrderDetails. Enter products ordered in subform.

1. An autonumber type field can accommodate generation of unique ID. Here is one way to filter form: http://datapigtechnologies.com/flash...tomfilter.html

2. You have a lot to learn before tackling something this advanced. Review: https://www.accessforums.net/access/...ils-36702.html