a field that shows values from 2 related fields?

[Deep Thought II]

hi, i have a question. is it possible to have a field that can show all the values from 2 other related fields?

for example... suppose i have a table that has [Order Number], and yet another table that has [Order Number] as well. now these two tables just has its own independant records and data.

then i wish to do accounting which will calculate the expenses of both table... is it possible to have one single [Order Number] that can show all the records from both tables?

thanks~

[Vaughan]

Make a separate relationship to each table.

[Deep Thought II]

thanks~