newbie, relating to a new record

[Pek]

Building a db for my girlfriend who runs a cleaning company. Set up a simple client contact db (clientContacts) with a portal that lets a client have more than one cleaning address (CareProperties , address etc) . Each client has a unique number . Each cleaning address had a unique number (House Id) displayed in portal.

Heres where i get stuck . I wnated to add a button to the portal so you could goto a new db (housedetails) based on the house Id, where you could add/change/view further details about whats to be cleaned , when etc. I can add a button fine but not sure how to relate the house Id in the portal to a new record in housedetails

Thanks in advance

Ric

[RalphL]

Use the Go To Related Record script step with the same relationship as the portal. Attach this script to the button in the portal row.

[Pek]

that works except it takes me back to the Careproperties db , which just holds the address. I wanted to be able to jump to a different database, Housedetails. Problem I seem to come up agaisnt is needing a record to be made in Housedetails whenever a new HouseId is created by Careproperties

Thank you for your help and sorry for not been clearer

Ric

[RalphL]

How many tables do you have? It sounds like 3, but do you need 3? What is stored in Housedetails that couldn't be in Careproperties? If you really need 3 tables then a portal in Careproperties would get you to Housedetails.

[Pek]

thanks your right i did nt need 3 tables after all can just make the button goto a new layout in Careproperties . I originally thought of careproperties just to hold the addresses and needed a seperate db for more indepth details . guess as always its best to keep it simple.

thanks again , was driving me nuts trying to figure it out

Ric

[Fitch]

Note that if you ever do need to implement something like that, you can put a script in the related file that goes to the related record in the third file. So you would GTRR in file B and run a script in file B that would take you to file C.