Please help :(....

[ronnie524]

Hello all, I really apreciate all the help I can get... Every database I am working with, I end up in the same problem and here is one of them ... I cannot get the description displayed from the invoice file... what am i doing wrong?

thank you in advance :...

1.zip

Edited November 3, 2005 by Guest
wrong file :(

[Inky Phil]

Ronnie,

I have fixed your file ( see attached).

The problem was that the description that you where showing in your order file layout was actually the description field from the relationship to productID so you had effectively not entered anything into the description field in the order file

HTH

Phil

amended.zip

[ronnie524]

Hey Phil,

Thanks for the fix... but I am not getting what I am actually lookinig for :. I am not sure if my database is related properly, where the portals display the data. (hope i am making any sense)... Here is what I am trying to do :

I have a Product database, Invoice database and a Order BD(Break Down) database.

On the product database: I have existing products with confidential info, selling cost, description

So...

On the Invoice::Portals all I want is to input the model# and the description and u. price displays from the "Product ID Database".

PS: I need the Order DB so later on I could check what my customers bought, or qty, or etc :.

The problem is that on my invoice: The description and U. Price would not show. If there is a better way to approach what I am doing please let me know.

... TY much!

[Inky Phil]

OK Ronnie,

the structure of your original file mislead me as to what you wanted. Give me a couple of hours (busy at moment) and I will give you a sample file that will do what you want and an explanation of where you are going wrong

Regards

Phil

[Inky Phil]

Right Ronnie,

Please see attached file that is somewhat different from your original.

I have added a file called 'invoice line items'. This is a temporary holding area for all the items on this particular invoice. It is this that you view and add to within the portal.

I have also added a constant field to each file to act as a 'pipeline' to send info back and forth.

I have added scripts that basically do the following:

Check that there is an invoice Number allocated.

Print the invoice.

Copy the invoice number into the line items file.

Copy the line items to your order BD (ie create a snapshot of that particular invoice and its items)

Delete all the line items ready for the next lot

Delete the invoice record ready for the next one

Take you back to the original layout.

What I have prepared may not be exactly what you wanted to achieve in the long run

- but -

It does demonstrate one method for pulling in your product data as requested

-and-

although I could not work out exactly what you wanted to achieve down the line with this I just had a stab at a very simple invoice and file routine in the hope that it might help you if you pulled it apart.

If you do reverse engineer it to see how the info gets around (I am afraid that I could not understand your own approach)pay particular attention in all the files to auto enter functions which might be a lookup or a calc field pointing to another field by relationship.

I don't pretend that this is the ideal way of doing what you want but I hope it helps you somewhat

Regards

Phil

restructured.zip

[ronnie524]

Thank you so much Phil, I am in great debt to you. I wish I could do something in return.

I didn't quite look at it careful yet, but I will definitely analyse what you did. I hope I'll get the hang of the portal issue looking at your restructured folder.

Let me know if there is anything I could do for ya... drop me an e-mail ...

Cheers!!!

Ron