1 Topic by eyeman303 (edited by eyeman303 2020-03-08 16:28:18)

  • Registered: 2018-12-02
  • Posts: 151

Topic: Setting up table grid auto query: a basic question

Hello,
I am trying to make a mutual fund investment database. I wish a table grid to display column VR_Rating which is a foreign key in the table AA_001_MF_SELECTION. The latter table is the parent table to the table under query AA_003_CURRENT_FUNDS. How to achieve this?

Post's attachments

Attachment icon AUTO_QUERY.JPG 96.12 kb, 132 downloads since 2020-03-08 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,687

Re: Setting up table grid auto query: a basic question

Hi Eyeman,
Can you attach your project?
Derek

3 Reply by eyeman303 (edited by eyeman303 2020-03-08 17:23:02)

  • Registered: 2018-12-02
  • Posts: 151

Re: Setting up table grid auto query: a basic question

Hello Derek,
I have attached the project. Please have a look.

Post's attachments

Attachment icon MF_Tracker_07.zip 482.2 kb, 237 downloads since 2020-03-08 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,687

Re: Setting up table grid auto query: a basic question

Hi,
I'd use a calculated field as you have no direct link between aa_003_current_funds and lu_005_vr_rating (see attached).
Derek.

Post's attachments

Attachment icon mftracker.zip 500.52 kb, 281 downloads since 2020-03-08 

5 Reply by eyeman303 (edited by eyeman303 2020-03-09 12:12:18)

  • Registered: 2018-12-02
  • Posts: 151

Re: Setting up table grid auto query: a basic question

Hello Derek,
Thanks a ton. You have again made my concept clear. When two tables are not directly related, to access data from the second table, a calculated field is required in the first table via a third table related to both the unrelated first & second tables. I have made the necessary calculated fields as you have shown and deleted unnecessary relationships. Now the app is working perfectly. smile  smile
eyeman303