V
ventron
We are trying to search by phone number and populate many fields in a
diferent form
diferent form
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
You probably shouldn't be populating "fields". You probably should be
displaying other field values in text boxes.
If you provide a little more information about your tables and form, maybe
someone can provide a solution.
displaying other field values in text boxes.
If you provide a little more information about your tables and form, maybe
someone can provide a solution.
V
ventron
It all has to do with customer info and parts i want the two tables to
populate a master form with like 7 fields number and letters.
populate a master form with like 7 fields number and letters.
D
Duane Hookom
Way to vague to make a guess regarding your tables, fields, form, and need
to store multiple copies of the same information.
to store multiple copies of the same information.
V
ventron
I would love to explane everything but i cant type it out would you be able
to call me e-mail me at [email protected] and ill give you my phone
number and we can acctually talk about it.
to call me e-mail me at [email protected] and ill give you my phone
number and we can acctually talk about it.
D
Duane Hookom
Sorry, won't happen. You may find someone who would accept a project but I
prefer to keep communications in the News Groups.
If you do find someone, please be prepared to pay for their time.
You really haven't made much of an attempt to describe your setup and
requirements.
prefer to keep communications in the News Groups.
If you do find someone, please be prepared to pay for their time.
You really haven't made much of an attempt to describe your setup and
requirements.
V
ventron
ok i was just checking i think its really hard to explain this im brad new at
this and have use up all ideas I have. Ok I have two tables, one is for
products and services with product ID used to look up, the other is customer
record with phone number as look up, and i all info from both pages displaied
in one record one a form and search for by phone number within that form. I
hope you understand. if that question bothered sorry you I just cant type
well i would reather talk.
this and have use up all ideas I have. Ok I have two tables, one is for
products and services with product ID used to look up, the other is customer
record with phone number as look up, and i all info from both pages displaied
in one record one a form and search for by phone number within that form. I
hope you understand. if that question bothered sorry you I just cant type
well i would reather talk.
D
Duane Hookom
Significant information is tables and fields. What are your table and field
names and what fields are use to link the tables?
There aren't generally "pages". Forms will display your data. A form has a
Record Source that is generally a table or query. Do you have a form? What
is its Record Source?
Apparently you want to select either a product ID or a phone number and
display the other fields from the table. If this is so, tell us what value
you are looking up and what fields you want to display.
names and what fields are use to link the tables?
There aren't generally "pages". Forms will display your data. A form has a
Record Source that is generally a table or query. Do you have a form? What
is its Record Source?
Apparently you want to select either a product ID or a phone number and
display the other fields from the table. If this is so, tell us what value
you are looking up and what fields you want to display.
V
ventron
thanks for contenuing with me. tables are 1. records, the fields are:
ID,customer name,phone number, address 2. products, the products fields are:
productID, product name, unitsinstock , and unit price.
The forms record source was the records table and the products table
looking up phone number in the record table and product id in the product
table
ID,customer name,phone number, address 2. products, the products fields are:
productID, product name, unitsinstock , and unit price.
The forms record source was the records table and the products table
looking up phone number in the record table and product id in the product
table
D
Duane Hookom
So these two tables are totally unrelated in any way. How could the form's
record source be both tables if they aren't related? Do you have an unbound
form with two combo boxes on it?
record source be both tables if they aren't related? Do you have an unbound
form with two combo boxes on it?