I have created a portal in a recipie file. The ingredient gets selected from a list, quantity gets put in etc. Its a self join relationship.

So, I create a new recipie, and theres the new portal, with the first line available. I fill it in, but then then next record in the portal does not appear. I can duplicate that first line, but I cant get another line to appear automatically after the first line is filled in.

I think you've got a bit of a mix up.

A recipe database would have:

1. A Table of Recipes (name, instructions, etc.)

2. A Table of Ingredients (to drive a value list perhaps) (Name, best vendor, etc)

3. A join table btw Recipes and Ingredients. This table would be your portal on the Recipe form layout. This table would also have Qty for each ingredient. You would design the printout for a recipe from this join table.

See this demo.

Recipes.zip

Cool, thanks for your response and the sample. Its actually from a fairly complex file I created that is stock management. I have included a recipie table within the file, so it looks up ingredients and prices from the list of stock we keep.

But I have gone off the rails somewhere. For instance, when I delete one of the portal rows, it deletes all records in the portal. Hmmm... Do you mind if I send to you and you have a look?

Steve

Just post your file with some data to the forum.

Thanks..I am new to posting, how do I attach the file?

On the reply page is a Manage Files link. You need to zip the file first.