Backwards relationship

[andrep]

I have a situation where i need to fill the many side of the table before the one side!

Will this pause a problem! Past present or futur!
I see no other possible venues to make this work!

ex: to pay bills i need to fill what needs to be paid
first!

Any suggestions !

 

[scking]

I don't understand why. Maybe if you showed your relational design.


tblVendors
VendorID {Primary Key}

tblPerson
PersonID {Primary Key}

tblBills
VendorID {Foreign Key}
PersonID {Foreign Key}

Steve King
Growth follows a healthy professional curiosity

 

[Craig0201]

Hmmm....

You got this all wrong.....

OK....

I get an invoice....what do I get an invoice or the line?? The invoice comes first.....

You can then choose to aggregate invoices to create payments.....

BUT the ONE comes first and ALWAYS does.....if you think otherwise, you've made a mistake.....

Craig

 

[andrep]

Right the invoice comes first!

Now the cheques comes next !
but for each cheque i can pay many invoices!

So the way i saw it was to use the invoice table which already contains the information to pay them!

Create a new table called cheques and link to the invoices
this is where my backward relationship comes in!

Else i wind up with a one to one relationship wich does
not fancy me !

I lookup up aggregate in the vb help which does not give me
enough information to set this up!

Thanks for any help you can provide

André

 

[Craig0201]

No.....

You've got it all wrong again....

The remittance comes next.....

Then the remittance lines......

And the remittance lines are 1-1 with invoices.....assuming you agree the invoice.....

Craig

 

[andrep]

Craig

Ok so we can make a one to one but this is unaceptable for various reasons which would end up in a long discussion!

Of course here the situtation here would be one to one based
on the fact that the invoice gets written before the payment!

So back to the original question (rephrased) !
Since there is no possible way to link the payment table other than a 1-1 relationship wich is not what i want ...

Is it ok to have unrelated tables within the same form so that i can transfer certain information to and from each
table.

I have succeeded in doing all the work here and it seems to
be ok.

All i wanted to know while using unrelated tables together
in a form will this be stable or will end up blowing up!

Thanks again
André