Hello

I am looking for some advice about portals, since I am a bit new to all this.

Basically I have a company table which holds fields such as company name and address and I have an employees table which holds the employees details. The tables are linked via a company id. I have a one to many relationship set up, as a company can have many employees. On the company table I want to have a portal where you can input the employees name which can be added to with more employees in the future, this list can be scrolled up and down and when you select the employee name it shows you their telephone details in another portal.

Does this sound sensible and is it possible?

I have just started playing around with and thought I would ask for some advice before I spend ages trying to do something that could be done in a much simpler way.

Any advice would be greatly appreciated.

Thanks

James

I Hope this helps (see file attached)

OS

Example.fp7.zip

FYI:

The phone number field has conditional formatting but the formula should be "AND" rather than "OR".

("my bad")

OS