Auto popultae field value.

[evanhughes]

Hi All

I have another problem and I don't even know where to start searching for a solution.

Is it possible to have fields populated from data in another table when a certain table has a particular entry.

The example is as follows.

When fielda table 1 = abc this is the same as field a in table 2
then fieldb table 1 = fieldb value from table 2
and fieldc table 1 = fieldc value from table 2

Any ideas

Evan

 

[jzwp22]

What you want to do is possible, but repeating the same data in more than one table violates good database practices. So, can you provide more detail as to what type of data you are working with and what you need to do with it?

 

[evanhughes]

When data is input to form via xls import fielda in table 1 has value eg:IL001.
In table 2 Fielda has values simillar to this and I want it to auto populate fieldb and fieldc in table 1 with values from corresponding values in table 2.

Eg:
Table 1
Fielda Fieldb Fieldc
IL001 PL1 Site2
IL002 PL2 Site2
SM005 PL8 Site4

So if fielda in table 1 has data imported from xls IL001 then fieldb and fieldc will have relavant data PL1 and Site2 autopopulated.

Hope this is understandable.

Evan

 

[jzwp22]

If there is a relationship between table1 and table2 via the value in fielda then you only need to use a query to bring the data together. There would be no need to copy data from table2 to table1.

What do these values represent: IL001 PL1 Site2?

Can you explain more about your application is doing?