Hello.I,m very new to this and on my 1st d/b.

I am trying to bring in to a portal situated in the main screen from an invoice table the invoice number and obviosly the customer name

i have created a relationship ---customer situated in main screen and customers in the invoice table.

Now comes the problem bit initially it seemed to work and brought in invoice numbers but they were all related to numbers long since deleted .

I deleted all these via a short script but end result is that nothing now is brought in

I have tried various combinations i.e invoice number to invoice number but to no avail

I,m obviously doing something that is inherently wrong

It is easy to bring in the numbers relating to the screen you are in tho

thanks

I'm not sure I completely understand what you want to do. However, I have posted an invoicing example on another thread that might help you or help you to explain your issue better.

http://fmforums.com/forum/showtopic.php?tid/179336/post/217436/hl//

Thanks I will look at that shortly.

One of my main concerns was related to the initial bringing in of records that had in earlier testing been deletd but thes actually showed up and im reasonably sure i did nothing else to any setting that one i had deleted thes via the small one line at a time scipt nothing else appeared

hello

i have altered your example as i have done in mine this may let you see where im going wrong

jacky

1155142445-joinprint.fp7.zip

ah just checked the revised sample i sent you portal i added isnt there. dont know why ill try again

resent hope this has alteration in it

joinprint2.fp7.zip

I downloaded the example and looked at your portal on the Customers layout and it looks like it is working great. It shows all the invoices for the customer. Maybe you can tell me what isn't right about the portal.

Hello

I know after i had sent I went back and looked at it again only thing I can think of is I perhaps had the system initially set to look in the join table or something

Many thanks for you help ..its good to know I can get assistance as I attempt to get the D/B to operate.

I sometimes feel as if i,ve bittten off a bit more than i,m able to handle this will ultimately be a full blown business D/B for a company with 35 employees, 470+ customers, 2300 different parts and so on.

jacky