Home > Archive > Clarion > February 2005 > SuperInvoice Template and Child Table (Help)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SuperInvoice Template and Child Table (Help)
|
|
| Guillermo J. Nard.. 2005-02-27, 8:55 pm |
| Hello people, well i have this situation and it costs me a lot of
problem.
i have a related table as you well see.
Customer
AddressCustomer
ZipCodes
Customer --> 1:N --> AddressCustomer --> 1:N ZipCodes
so in a form i add a superinvoice template to fill AddressCustomer, but
this table (AddressCustomer) looks-up a ZipCode and superinvoice tells
me that it is incompatible to do that, because of the relationship
between AddressCustomer and ZipCodes
There have to be no-links (Relationships) between AddrresCustomer and
ZipCodes,
but if it is doesn't exist (the relationship) i can't do a look-up.
does anybody has this issue?.
otherwise, i have another issue with superinvoice and this is it..
when i delete a record on the superinvoice and i save data, it
duplicates records (not deleted by the users)
why?
thank you so much,
Guillermo
from Argentina
| |
| Rocky Phelps 2005-02-28, 3:55 am |
| > Customer --> 1:N --> AddressCustomer --> 1:N ZipCodes
This appears to me to be incorrect. It says that you can have many addresses
for a customer - that part is okay - but it also says that one address can
have multiple ZipCodes - that part is incorrect in my mind. You should be
able to have multiple addresses per ZipCode, not multiple ZipCodes per
address.
Rocky
"Guillermo J. Nard.." <gjnardoni@gmail.com> wrote in message
news:1109537942.624814.124210@l41g2000cwc.googlegroups.com...
> Hello people, well i have this situation and it costs me a lot of
> problem.
>
> i have a related table as you well see.
>
> Customer
> AddressCustomer
> ZipCodes
>
> Customer --> 1:N --> AddressCustomer --> 1:N ZipCodes
>
> so in a form i add a superinvoice template to fill AddressCustomer, but
> this table (AddressCustomer) looks-up a ZipCode and superinvoice tells
> me that it is incompatible to do that, because of the relationship
> between AddressCustomer and ZipCodes
> There have to be no-links (Relationships) between AddrresCustomer and
> ZipCodes,
> but if it is doesn't exist (the relationship) i can't do a look-up.
>
> does anybody has this issue?.
>
> otherwise, i have another issue with superinvoice and this is it..
> when i delete a record on the superinvoice and i save data, it
> duplicates records (not deleted by the users)
>
> why?
>
> thank you so much,
>
> Guillermo
> from Argentina
>
|
|
|
|
|