Database Help maybe design help

  • Thread starter Thread starter ckloch
  • Start date Start date
C

ckloch

I have a database with 3 major tables in it as follows...

Table one
Old fund
Client Number
Effective Date
New Fund


Table Two
Fund Number
Fund Name
Fund Ticker
Fund Category
Performance Date
Performance numbers


Table three
Client Number
Client Name
Client Address
etc

What I need to accomplish in the end is a report that shows the old
fund from table one the new fund from table 1, the fund category and
ticker for the old fund (comes from table two) and the fund category
and ticker for the new fund (which is also stored in table two) by
client. I have a one to many relationship for the old fund in table
one to the fund number in table two.... I can not for the life of me
figure out how to set up a form to chose the new funds and then pull
it into a report with all the necessary information on the new fund.

Help is very much appreciated as I am running out of time on how to
get this set up...
 
ckloch said:
I have a database with 3 major tables in it as follows...

Allow a little time please. Your original request was made less that 20
minutes ago.

If you have additional or clearer information it would be best to post
in as a reply to your original message.
 
Back
Top