MS Access 2007-syncronizing 3 text fields

[Born2Gamble]

Having trouble figuring this out..

On my main table,(Table1) I have the below, I want it so that when I type sample1 on my main table, it auto fills in the address,city/state with the info from table2

Name........ Address ..........City/State
sample1
sample2
sample3
---------------------------------------------------------
I have Table 2 with a list of contacts

Name ............. Address .........City/State
sample1 ......... 123 pine st ..... downey,ca
sample2 ..........456 apple st...... downey,ca
sample3 ......... 788 vine st......... downey,ca

help is much appreciated, im going crazy over here..

[June7]

If you want to actually save this data to table will need to use VBA code. Is it really necessary to save this data (duplication?) or just the record ID for the address record? Save record ID and can display the address info on form by joining Table2 to Table1 in the form's RecordSource, jointype 'Show all records from Table1...'

[Born2Gamble]

I basically have alot of fields

Origin City|State|Destination| Rate| pickup date|delivery date etc

I have a form that makes an invoice from the data I inputed there.


All I need is for that when I type a customers name in one field, I dont have to re-type his adddress,phone,fax etc every single time in the other text fields.


Name........ Address ..........City/State...........Phone.......Fax
sample1
sample2
sample3

Sorry if this doesnt answer your question, I have bearly started using access and have learned/still learning most of it by watching youtube videos.

[June7]

Main principle of relational database is to not repeat data. Data is organized in related tables. Tables are linked on primary and foreign keys. Each record in customer info table should have a unique ID (maybe CustomerID). Save this unique ID to the Deliveries table. Do not repeat saving the address info. Whenever you need the address for that delivery retrieve it by joining the two tables on the CustomerID fields.

BTW, don't use names as unique ID. This will cause big problems.

[Born2Gamble]

If I can have 1 table, just filling out

Name | Origin City| State|Destination| etc
instead of filling out.....
Name |Address|City|state|phone|fax|Origin City| State|Destination|



and have another table just for the detailed information about the "Name" , that would be awesome


As logn as I am able to make a Form and pull data from both lists

So that when I make a specific invoice on a certain load #

on the Form it will say

name .............phone
address............fax
city/state

Origin City| State|Destination|



instead of just
Name

Origin City| State|Destination|

[Born2Gamble]

ah so Basically, I create a relationship between "Name" in my main table (Table1) and "Name" (table2)

I have my main table just show
Name|Origin City|etc etc ( but no address,phone, fax etc)

and have table 2 show
name\address\citystate\phonefax
-make a form for this

Then Create a form using my master table, and put in a subform ( from Table2)

Am I doing it wrong

[June7]

This is some kind of delivery/courier business? Addresses can get complicated. Origin, Destination, Billing, etc. Have a table of just address info. Save the unique id for address in each address field of the delivery table. Save unique id for address in customer info table.

Here is a nice, long thread that dealt with this topic. http://forums.aspfree.com/microsoft-...ct-353195.html

[Born2Gamble]

There was a data macro that worked but it only let me put numbers and no letters..It was a Change Before data macro, which works, but on the "set field" "value box, it only allowed numbers and no letters..which i need for 123 apple st....anyway around that because that would be the easiest for me to implement.


Transportation business
I have these fields
Book Number(also my invoice)|origin city|st|destination|st|Pickup date|time|arrival date|time| Bill of Lading(like a fedex#)shipper name|shipper rate|Carrier name|carrier rate|Carrier address|Carrier Phone|Fax|

I have made it so far that my booknumber is now an autonumber, so when I create a new book number(invoice or load#) it auto increments and I wont double book something.

Ive only seen a query do what I want, but I dont want to have to make a query for EVERY single new customer I get, and then have to run each and every query when Im going to make an invoice.



Going to check out that thread