pls help here, I am all confused:
I have a table of vendors, projects and bills
I am displaying multiple vendors in projects table associated with that project. (in one field)
I want to show a link in that field which should take me to bills (existing or new)
Not sure how to do that.
I have following accessible fields in projects: project_id, vendor_id
Bills have the following field:
project_id, vendor_id, bill_id