Access adding several one to many relationships

[Jason Smith]

I am considering using infopath to develop a budgeting tool for several cost
centers. In my test, I have three tables Cost Center Master, Chart of
Accounts, Budget Data. Cost Center Master and Chart of Accounts are both one
to many relationships with Budget data. How can I pull in All info from
Budget Data and only the Cost Center description from Cost Center Master and
the Account Description from the Chart of Accounts?

 

[S.Y.M. Wong-A-Ton]

If you are using Microsoft Access, you can create a Query using the
appropriate joins between the tables and then use this query as the data
source to your form. If you are using SQL Server, you can create a View using
the appropriate joins between the tables and then use this view as the data
source to your form.