⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

How to create view for a field from all tables it is related to

Started by desi0, 23 April 2012 - 05:36 AM


desi0

desi0
  • profile picture
  • Member

Posted 23 April 2012 - 05:36 AM

Thank you Johnny for a wonderful library.

I'm trying to create a view showing all the info related to 1 user in a page. Can you please help me out
I have 3 tables users ,cars, gascards.
usertable -- userid(PK) , name, email,phone,project, market,usergroup.
cars - carid(PK),nameofrenter,rentalcontract,rentedat ,...,userid(FK)
gascards- gas_id(PK),type, cardnumber,project,...,userid(FK)

when i click on user can I get all the info from all the tables that are related like an invoice style


User Info
Name
Email
Phone

Car Used:
complete car rental info

Gas cards:
Card number
Used in Market
Used in Project

Thanks once again for the library

web-johnny

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 23 April 2012 - 06:08 AM

This is the 1-1 relation that grocery CRUD doesn't have this functionality yet. It depends of how much time I will have in the future to do that and/or if I have any good donations till then.

This functionality is a big deal and also really complicated to do it, but I think it will save lot of time for many users when it will come up.