table

[nishkrish]

i have a table suborder Table

Suborder ID Number
i created another field Customer No. Number

I have CustomerOrder Table
which has Customer No field

when i open suborder table i see customer No field blank how can o bring the
records fron customerOrderTable to subOrder Tbale.

Thanks

Nisha P

 

[mscertified]

Write a query to join the two tables and open the query instead of the table.
Look up JOIN in Access help.

-Dorian.

 

[John W. Vinson]

i have a table suborder Table

Suborder ID Number
i created another field Customer No. Number

I have CustomerOrder Table
which has Customer No field

when i open suborder table i see customer No field blank how can o bring the
records fron customerOrderTable to subOrder Tbale.

Ok... let me see if I understand.

You have a table with a lot of customers.

You have another table with a lot of subOrders (I'll have one with Provolone,
Swiss and sharp Cheddar, hold the pickles but all the .... oh... sorry...)

You currently have nothing in either table (that you've mentioned anyway) that
would indicate WHICH record in the Customers table should be linked to any
particular subOrder.

If you had two stacks of paper, one with all the information about customers,
the other with all the information about subOrders, how would you identify
which customer goes with which suborder?

John W. Vinson [MVP]

 

[nishkrish]

Hi John,

when order comes in Customer No is created so its unique and primary key of
my Customer Order Tbl i have another tbl Suborder Tbl so to create
Relationship Between Tbl i added CustomerNo. Field to Suborder Table .
Suborder No. is unique and again primarykey.
I created a query and added certain fields to it one of which is CustomerNo.
Field which comes from Customer Order Tbl and it has 5 records in it and
project Initation Date again from Customer Order Tbl but when i give Creteria
between 1/5/2007 and 1/31/2007 it doesnt show records all the rows are
completely blank is null or is not lull doesnt work either.

I am not sure if this makes sense thats the reason many times i posted my
tables and asked if its properly Normalised

 

[John W. Vinson]

Hi John,

when order comes in Customer No is created so its unique and primary key of
my Customer Order Tbl i have another tbl Suborder Tbl so to create
Relationship Between Tbl i added CustomerNo. Field to Suborder Table .
Suborder No. is unique and again primarykey.
I created a query and added certain fields to it one of which is CustomerNo.
Field which comes from Customer Order Tbl and it has 5 records in it and
project Initation Date again from Customer Order Tbl but when i give Creteria
between 1/5/2007 and 1/31/2007 it doesnt show records all the rows are
completely blank is null or is not lull doesnt work either.

I am not sure if this makes sense thats the reason many times i posted my
tables and asked if its properly Normalised

I think the tables are fine; the problem is with how you're entering the data.
It sounds like you may be entering data directly into your Tables. Don't!
Tables are NOT designed for the purpose; you should only open a table
datasheet for debugging or design work.

Instead use a Form based on the Customer table, with a Subform based on
Suborder. Use the CustomerNo as the master/child link field of the subform
(Access will do this automatically if you have a relationship defined and use
the wizard). This will ensure that the correct CustomerNo gets filled in when
you enter a new Suborder record.

John W. Vinson [MVP]

 

[nishkrish]

Thanks John I really appreciate your help all of the replies that you have
provided me till date are not ony good but also understandable.