Match Record with other forms

  • Thread starter Thread starter LJ
  • Start date Start date
L

LJ

Okay let me try to explain as clear as i can...
I have two different forms, in Form1 (CheckInTicket) i have information for
client who checked in and in Form2 (Loading Check List) is for those who are
being attendent to. There is three or four field that are identical in both
forms, one of those being the Order Number. Now my question is, how do i go
about typing in the order number in form2 (Loading Check List) and have the
three and four field automatically filled based on the information provided
or corresponding to the first form (Form1[CheckInTicket])

If Un-clear or more information is needed please feel free to let me know.
Any assistance on this matter is, as always, Higly Appreciated!

Thank you in adavance

LJ
 
Stop now! First, Access stores data in tables, not forms.

Next, if the data already exists in the [CheckIn] table, there's no good
reason (and lots of bad ones!) to store the same exact data again in your
[Loading] table.

That said, if you only wish to see what was in the other 3-4 fields, you can
do this in your form using unbound textboxes, whose values you set by using
a combobox to select the client, and the combobox's AfterUpdate event to set
the values for display.

Depending on your data structure (you've only described your forms so far),
you could even use a main form/subform construction.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Okay, let me start over...

I have created a database, starting with two tables, out of those two tables
i have created two forms, the same fields can and are being stored, the only
problem is, that for example, when i type in the information in the first
form...like the order numb and the client....when im ready to attend that
same client, i have to retype his im formation...(his order number and the
clients name, again). Since i have that information in the other table....My
question then is, How do i assosiate that information based on the commond
field.

Ex:

Table one - Form 1:

order Num 12345678
Client: His name here

So i would like to Now in Table two - Form 2:


Type in Order Num: 12345678
Have it look up that order number and then
Fill in the name assosiated to that order Num:

Table 2 - Form2:

Order Number: (Type) 12345678

Is that Possible: (Auto Fill) His Name Here



Jeff Boyce said:
Stop now! First, Access stores data in tables, not forms.

Next, if the data already exists in the [CheckIn] table, there's no good
reason (and lots of bad ones!) to store the same exact data again in your
[Loading] table.

That said, if you only wish to see what was in the other 3-4 fields, you can
do this in your form using unbound textboxes, whose values you set by using
a combobox to select the client, and the combobox's AfterUpdate event to set
the values for display.

Depending on your data structure (you've only described your forms so far),
you could even use a main form/subform construction.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

LJ said:
Okay let me try to explain as clear as i can...
I have two different forms, in Form1 (CheckInTicket) i have information
for
client who checked in and in Form2 (Loading Check List) is for those who
are
being attendent to. There is three or four field that are identical in
both
forms, one of those being the Order Number. Now my question is, how do i
go
about typing in the order number in form2 (Loading Check List) and have
the
three and four field automatically filled based on the information
provided
or corresponding to the first form (Form1[CheckInTicket])

If Un-clear or more information is needed please feel free to let me know.
Any assistance on this matter is, as always, Higly Appreciated!

Thank you in adavance

LJ
Click to expand...
Click to expand...
 
OK, you've got tables. Access is a relational database, so your tables need
to store well-normalized data if you're to get the best use of Access'
features/functions.

If you have the same (or very similar) fields in more than one table, spend
some time studying up on normalization. Many (similar/identical) tables is
a very spreadsheetly way of doing things, but not in Access.

For example (and only guessing, since you haven't described your domain or
data in particular detail), maybe you could add a single field to your first
table to show that (or when) the client moved to the new status?

Or if you have a client progressing through more than Prospect/Customer
(i.e., two statuses, stati, ...?!), you may have a "one-to-many"
relationship.

Provide a bit more specific description about your domain and data -- folks
here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

LJ said:
Okay, let me start over...

I have created a database, starting with two tables, out of those two
tables
i have created two forms, the same fields can and are being stored, the
only
problem is, that for example, when i type in the information in the first
form...like the order numb and the client....when im ready to attend that
same client, i have to retype his im formation...(his order number and the
clients name, again). Since i have that information in the other
table....My
question then is, How do i assosiate that information based on the commond
field.

Ex:

Table one - Form 1:

order Num 12345678
Client: His name here

So i would like to Now in Table two - Form 2:


Type in Order Num: 12345678
Have it look up that order number and then
Fill in the name assosiated to that order Num:

Table 2 - Form2:

Order Number: (Type) 12345678

Is that Possible: (Auto Fill) His Name Here



Jeff Boyce said:
Stop now! First, Access stores data in tables, not forms.

Next, if the data already exists in the [CheckIn] table, there's no good
reason (and lots of bad ones!) to store the same exact data again in your
[Loading] table.

That said, if you only wish to see what was in the other 3-4 fields, you
can
do this in your form using unbound textboxes, whose values you set by
using
a combobox to select the client, and the combobox's AfterUpdate event to
set
the values for display.

Depending on your data structure (you've only described your forms so
far),
you could even use a main form/subform construction.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

LJ said:
Okay let me try to explain as clear as i can...
I have two different forms, in Form1 (CheckInTicket) i have information
for
client who checked in and in Form2 (Loading Check List) is for those
who
are
being attendent to. There is three or four field that are identical in
both
forms, one of those being the Order Number. Now my question is, how do
i
go
about typing in the order number in form2 (Loading Check List) and have
the
three and four field automatically filled based on the information
provided
or corresponding to the first form (Form1[CheckInTicket])

If Un-clear or more information is needed please feel free to let me
know.
Any assistance on this matter is, as always, Higly Appreciated!

Thank you in adavance

LJ
Click to expand...
Click to expand...
Click to expand...
 
Okay Lets try this one more time:

I have Two different tables...They are linked, relationship between them is
the Order Number field...Now on the second table one I would like just type
in the order number and have two to three field copied from the first
table...you know instead of all 15 fields.

So 1st form/Table:

Order Num:
Customer:
Time:
Date:
Lic:
Etc:

Now i would like to:
on 2nd Form/Table

Type in
Order Num: ######

and get

Customer: Auto (Based on what is entered in 1st table/form)
Lic: Auto ( " ")


Is there a code for this or is it simpler that this...



Jeff Boyce said:
OK, you've got tables. Access is a relational database, so your tables need
to store well-normalized data if you're to get the best use of Access'
features/functions.

If you have the same (or very similar) fields in more than one table, spend
some time studying up on normalization. Many (similar/identical) tables is
a very spreadsheetly way of doing things, but not in Access.

For example (and only guessing, since you haven't described your domain or
data in particular detail), maybe you could add a single field to your first
table to show that (or when) the client moved to the new status?

Or if you have a client progressing through more than Prospect/Customer
(i.e., two statuses, stati, ...?!), you may have a "one-to-many"
relationship.

Provide a bit more specific description about your domain and data -- folks
here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

LJ said:
Okay, let me start over...

I have created a database, starting with two tables, out of those two
tables
i have created two forms, the same fields can and are being stored, the
only
problem is, that for example, when i type in the information in the first
form...like the order numb and the client....when im ready to attend that
same client, i have to retype his im formation...(his order number and the
clients name, again). Since i have that information in the other
table....My
question then is, How do i assosiate that information based on the commond
field.

Ex:

Table one - Form 1:

order Num 12345678
Client: His name here

So i would like to Now in Table two - Form 2:


Type in Order Num: 12345678
Have it look up that order number and then
Fill in the name assosiated to that order Num:

Table 2 - Form2:

Order Number: (Type) 12345678

Is that Possible: (Auto Fill) His Name Here



Jeff Boyce said:
Stop now! First, Access stores data in tables, not forms.

Next, if the data already exists in the [CheckIn] table, there's no good
reason (and lots of bad ones!) to store the same exact data again in your
[Loading] table.

That said, if you only wish to see what was in the other 3-4 fields, you
can
do this in your form using unbound textboxes, whose values you set by
using
a combobox to select the client, and the combobox's AfterUpdate event to
set
the values for display.

Depending on your data structure (you've only described your forms so
far),
you could even use a main form/subform construction.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Okay let me try to explain as clear as i can...
I have two different forms, in Form1 (CheckInTicket) i have information
for
client who checked in and in Form2 (Loading Check List) is for those
who
are
being attendent to. There is three or four field that are identical in
both
forms, one of those being the Order Number. Now my question is, how do
i
go
about typing in the order number in form2 (Loading Check List) and have
the
three and four field automatically filled based on the information
provided
or corresponding to the first form (Form1[CheckInTicket])

If Un-clear or more information is needed please feel free to let me
know.
Any assistance on this matter is, as always, Higly Appreciated!

Thank you in adavance

LJ
Click to expand...
Click to expand...
Click to expand...
 
And again, why? Why do you want to have ANY of the field values already
stored in table one be "copied" to table two?

That's how you'd do it with a spreadsheet.

Trying to duplicate that approach in a relational database will only
frustrate the database and cause YOU considerably more work than you need to
do.

You can pay now, or pay later ... if you don't normalize your data first,
you'll be paying for a long time!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

LJ said:
Okay Lets try this one more time:

I have Two different tables...They are linked, relationship between them
is
the Order Number field...Now on the second table one I would like just
type
in the order number and have two to three field copied from the first
table...you know instead of all 15 fields.

So 1st form/Table:

Order Num:
Customer:
Time:
Date:
Lic:
Etc:

Now i would like to:
on 2nd Form/Table

Type in
Order Num: ######

and get

Customer: Auto (Based on what is entered in 1st table/form)
Lic: Auto ( " ")


Is there a code for this or is it simpler that this...



Jeff Boyce said:
OK, you've got tables. Access is a relational database, so your tables
need
to store well-normalized data if you're to get the best use of Access'
features/functions.

If you have the same (or very similar) fields in more than one table,
spend
some time studying up on normalization. Many (similar/identical) tables
is
a very spreadsheetly way of doing things, but not in Access.

For example (and only guessing, since you haven't described your domain
or
data in particular detail), maybe you could add a single field to your
first
table to show that (or when) the client moved to the new status?

Or if you have a client progressing through more than Prospect/Customer
(i.e., two statuses, stati, ...?!), you may have a "one-to-many"
relationship.

Provide a bit more specific description about your domain and data --
folks
here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

LJ said:
Okay, let me start over...

I have created a database, starting with two tables, out of those two
tables
i have created two forms, the same fields can and are being stored, the
only
problem is, that for example, when i type in the information in the
first
form...like the order numb and the client....when im ready to attend
that
same client, i have to retype his im formation...(his order number and
the
clients name, again). Since i have that information in the other
table....My
question then is, How do i assosiate that information based on the
commond
field.

Ex:

Table one - Form 1:

order Num 12345678
Client: His name here

So i would like to Now in Table two - Form 2:


Type in Order Num: 12345678
Have it look up that order number and then
Fill in the name assosiated to that order Num:

Table 2 - Form2:

Order Number: (Type) 12345678

Is that Possible: (Auto Fill) His Name Here



:

Stop now! First, Access stores data in tables, not forms.

Next, if the data already exists in the [CheckIn] table, there's no
good
reason (and lots of bad ones!) to store the same exact data again in
your
[Loading] table.

That said, if you only wish to see what was in the other 3-4 fields,
you
can
do this in your form using unbound textboxes, whose values you set by
using
a combobox to select the client, and the combobox's AfterUpdate event
to
set
the values for display.

Depending on your data structure (you've only described your forms so
far),
you could even use a main form/subform construction.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Okay let me try to explain as clear as i can...
I have two different forms, in Form1 (CheckInTicket) i have
information
for
client who checked in and in Form2 (Loading Check List) is for those
who
are
being attendent to. There is three or four field that are identical
in
both
forms, one of those being the Order Number. Now my question is, how
do
i
go
about typing in the order number in form2 (Loading Check List) and
have
the
three and four field automatically filled based on the information
provided
or corresponding to the first form (Form1[CheckInTicket])

If Un-clear or more information is needed please feel free to let me
know.
Any assistance on this matter is, as always, Higly Appreciated!

Thank you in adavance

LJ
Click to expand...
Click to expand...
Click to expand...
 
Back
Top