Access adding several one to many relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Smith - 27 Mar 2006 15:55 GMT

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?

Reply to this Message

S.Y.M. Wong-A-Ton - 27 Mar 2006 19:03 GMT

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.
---
S.Y.M. Wong-A-Ton

> 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?

Reply to this Message