linkage

[Tech]

Hi again, firstly I like to thank the people who helped me through a coursework i needed help on, you have been great! THANK-YOU

I trust u ppl

I am now in the second semester and it's a project type module.

I need some help before I continue.

On paper, I have done/drawn up some relationships of tables etc...

The database is based on a company who make and sell some items/products and they are planning to implement technology/electronic format of organising this stuff.

Now, I have made up these tables needed, on paper:

Customer Details
Product Details
Unpaid Orders
Customer Order History
Order form

now, I am a newbie so please, talk easy on me!

Right what I want to know is some information for the order form:

I have decided to put in a subform in the order form, this subform is for the customer details.

Lets say, IF we enter an exisiting customer number, how can I tell it to bring up the customer details eg:

If customer number 1234 was Joe Bloggs, it should pull up this info from the Customer Table:

Joe Bloggs
1234 high street
Bloggs Land
ABC 123


is it possible? If so, how??

OK, so if the user doesn't enter and existing customer number, a new record is created, great.

If the exisiting customer is entered, and the user enters an EXISITING PRODUCT NUMBER from the Product Table, how can I tell it to show up the details of that product on the Order form table from the product details table? And then, how does it save all that ? Does it save all the order information in it's own table?


Sorry if it sounds complicated, I need help ASAP. I am trying very hard here, more than the group anyway and I am the key role in this. I just need to clear these small things up first otherwise I am doomed and don't want that.

So please, help me and if u r, explain in nice easy steps

Thank-you

God Bless

 

[Hayley Baxter]

Hi Tech

It might be an idea for you to look at the Northwind.mdb. As this is very similar to what you are trying to achieve. It will show you the setup of the tables, queries, forms, reports etc.

Have a look there first as that will be a good start.

Hayley

 

[Tech]

Thanks, I will try it.

I haven't had time to check it out but please, I need to know from a good person like urself, will it do what I have said I want it to do? I mean, of course, Not everything but will it do the part where, if u have a subform in a form, and u enter a customer number, if that customer number exists, all the details of that customer appears and u can continue otherwise if not, then a new customer is made and u can continue on...

will it do that? If not, how can I tell it to do it? Please help, i am having a panic attack

 

[Hayley Baxter]

Don't panic you will be fine. There are various different methods to do what you require and they are usually quite straightforward to implement. It's just the fear of the unknown but once you get into it it will all make sense.

I can send you on some examples if you want to take a look at how this can be achieved but do look at the Northwind as that is a very good example.

If you want any samples drop me an email.

Hayley

 

[Tech]

I can't seem to find the northwind database in MS Access (I am using Office XP and Office 2000), would u be able to email me it or something?

 

[Rich]

It should be in the Samples folder

 

[Tech]

thanks, will have a look. I'm really going mental here, crazy lol. I haven't yet started the database yet and having problems.

Right, so, you are saying that it is possible if, I make a database with a customer details subform in an order form.

The order form may contain these fields:

product number
product type
price
...

And, if we enter a customer number, the details of that customer SHOULD appear, we can then start ordering. Lets say if customer 123abc orders like this:

Cust number: 123abc
Product num: DEFGHI
Product type: table
price: £15.99

Will it save the order details so that, when we next time enter this customer number, the order details should appear?

Obviously, if that customer doesn't exist, a new record would be created, but then if we make the customer number as a primary key, won't we have problems where if we enter an existing customer number, it will complain cause of dupilcate records?

HELP!!!

 

[Tech]

it's not in the samples folder...still can't find it

 

[Tech]

really stuck and frustrated on this database

 

[Hayley Baxter]

If you're stuck for a copy send me an email and I'll send it onto you.

HayleyBaxter716@hotmail.com

 

[Tech]

i've nearly got it sorted out, i hope u don't mind me adding u on my msn

 

[Hayley Baxter]

Not at all. Feel free to chat to me anytime when I'm online. I'm usually around after 6pm on weekdays or at the w/end

Hayley

 

[Tech]

ty c u at 6pm then hehe