Display field where condition in other fields are met

[assets]

The data base has a number of table the the one yahe this affect is addresses and division

There is a field in Table Addresses called divisionID thay has a lookup
SELECT Division.DivisionID, Division.Division, Division.Active, Division.CostCentre FROM Division WHERE (((Division.Active)=-1));

Table Division has DivisionID (auto No) Division ( List of names) and Cost centre (number)

What I like to do is use the costcentre field infomation from Division to polulate a field in Addresses with the costcente info that is in division where the Divisionid in both table are the same.

Never give up never give in.

There are no short cuts to anything worth doing

 

[randy700]

Why would you want the same data in both tables?
This is generally considered bad practice.
A more common method would be to link the tables and obtain the costcentre information from a query.

Randy

 

[assets]

I really need the correct data on the form. Wher the division table only has 12 entries the address has 200 and having all the information pulled in makes it easier to view. The problem is it not getting the costcentre info correctly. Yes just being it displaying the costcentre data on the form would be good except I can not get that to happen either.

Never give up never give in.

There are no short cuts to anything worth doing