Relationships, 2 portals in a layout

[atoner]

Hello, first of all I apologize if I am not posting in the right place but I'm kinda lost and my English is not very good

 

I'm trying to make a database for recording projects, these projects can be of various clients. I could not develop until want to develop more

 

Here's what I wanted to do

 

A company may have multiple departments (eg markting, sales, purchases), have the project and its data, referring to stock products that can be sold in this work and a description free.

 

The best way I found to do this, do not know whether or not compliquei with table

 

customers - cliente

Departments - departamento 

jobs - trabalhos

Job data - dados do trabalho

products - produtos

materials - materiais

 

What has not been able to associate departments firms (not very important)

 

Now more importantly, wanted layout "job data" have two portals, one in introducing the product description or work done and the other shows up old material in this work.

 

I'm trying to write a better explanation but my English is not even any good. In order to try to help leave a link here than I have in order to see better. It has some notes on the layout "data work" where everything goes.

 

https://dl.dropbox.com/u/52467771/MR%20test.fmp12

 

I would appreciate some help and even if I'm on a good path for this to work;)

 

thank you very much

 

 

There is the file, hope its work 

MR test.zip

[Lee Smith]

Why didn't you post your file here?

 

 

If you have already tried to do this, and it didn't work, try following these steps.

zip your file.

Use the More Reply Option.

Step 3

Click on Choose Files 

Find the file on your hard drive.

click Attach This File, and then click Add Reply.

If you should have a problem let me know.

 

HTH

 

Lee