I created a portal that is supposed to have different values in them but when ever i try to add another one, it replaces the previous one rather using the second line. I am very new to this program and I would be grateful for any help.

ex:

i want it to show two records that are unique (pre-set from a different table), but it only shows one, the most recent choice.

Edited February 19, 200916 yr by Guest

It is most likely a relationship problem. Don't worry most of us have them.

How is your relationship set up between the main table (The Parent) and the Portal Table (The Child)?

Make sure that you checked the box in your relationship so that it allows new records to be created through the relationship.

******************

These are just some other thoughts that could cause a problem in a portal:

How many rows are you showing in the portal? If more than one, Are you able to enter the fields on the second line?

Are the fields, in layout mode, properly centered within the line on the portal?

If you have checked all of these items and are still having trouble post a clone of your file and let us take a look.

hth

I checked and i have both the create and delete options checked in the relationship one. this is the problem area right here if you could take a look at it, it would be much appreciated.

abc_clone.fp7.zip

Your setup is way-off. Take a look at this typical invoice setup. Pay attention to how key fields are used.

InvoiceDemo.fp7.zip

thanks for the help, odds are i'm going to have to start from scratch at this. I don't know what happened but i'm going to re-create my tables. I would still appreciate more help/advice if anybody has any.

Can somebody look at this for me? I looked at what you gave me but i can't replicate it or follow it. The portal just doesn't work, so i started over, but i'm stuck in the same spot. The question is how can i add a new portal row with a different record/value.

Test_Remake.fp7.zip

Edited February 24, 200916 yr by Guest

You have missed the point. Think of what the invoice does. It bring together many components of information into once place.

For example, you can have a table of customers, pricing schedule, employees that did the work etc on it. Then there is information that is specific to the invoice itself such as invoice date, invoice number, etc. Since the invoice should reflect the information about the point in time that it was created, the information such as customer and pricing should be looked up from their tables and stored into field in the invoice table.

Additionally, an invoice usually have many line items. If you take a look at Barbara's example, she has a line items table that is displayed as the portal. This line items table stores the invoiceID, productID, and other information such as the price and qty.

You can turn on "Allow creation of record" to the lineitems table. Your value list of productIDs should be based off your Product Table. When you choose the productID from teh drop down in the portal, it should create a new line items record for you.

I know what was wrong with my database. I was missing a joined table. I had charge, and product repair invoice table and i was trying to store information where it's not possible. Now i made a charges_made table that can store multiple charges for a single repair no. (what i was trying to do in the first place). In the end it wasn't the way the portal was set up, it was the way the database was set up.

I know I am coming off as super-duper noob, but that's because i am, and i'm thankful for everybody's help.

Here is the new version of the database, but i can't figure out how to add rows in the portal and have it show in the charges made table. I'll mess around some more and see how it goes. Again thanks for the help.

Test_Remake_2.fp7.zip

Edited February 24, 200916 yr by Guest

Yes that was what we were trying to say. Your issues was a relationship structure issue.

Go to your relationships graph. Click the "=" sign between the Product_Repair_INV table occurence and the ChargesMade table occurence. Check the "Allow Creation of Records..." on the Charges Made side.

Everything is almost working fine except for an issue with subtotals. I can't seem to get the sub totals to work with the values in my portal. My calculation is "sum (chargesmade, charge amount)", but it doesn't list anything in the subtotal. Is there something wrong with the way i defined the fields?

Test_Remake_2.fp7.zip

Edited February 26, 200916 yr by Guest

Everything is almost working fine except for an issue with subtotals. I can't seem to get the sub totals to work with the values in my portal. My calculation is "sum (chargesmade, charge amount)", but it doesn't list anything in the subtotal. Is there something wrong with the way i defined the fields?

But it isn't a calculation; you have defined it as an auto-enter text field. Change to a calculation.

testremake.zip

Edited February 27, 200916 yr by Guest

Thanks a lot for the fix. It's obvious that my databasing skills still have a long way to go and i'm very grateful for all of the help. Thanks Bcooney, Mr.Vokda, BruceR.

Edited February 27, 200916 yr by Guest