Relationship or Lookup?

[Mats]

Hi Guys!

I am a total newbie and this is my first post here

I still work on my Invoice db and now have a new problem:

In my Invoice I have a Value List for different Currencys ie. "

[LaRetta]

Hi Mats,

Good to see you on Forum and welcome!

I think it might work better to store your Bank Account details in your Contacts file, as each Contact will have different account information. And since the bank account information is a 1:1 (one-to-one) with your Contacts, that's where it might be better suited. If each Contact has more than one Bank Account, you would want to keep your Bank Details db instead and include a field for ContactID so each record reflected a different account for each Contact. Your Statement of Account report could then be generated from your Contacts file instead of the Invoice file. It would then work to have a Bank file, which would contain specifics about each Bank (such as their phone number, address, etc.).

If you established the above type of structure, when an Invoice is created and the ContactsID is inserted, the Bank Account details would (could) appear below the Contact address, etc. The account information, after all, would apply to the Invoice and not the LineItems. Just something to consider.

Even so bad that if I make a Relationship "Banking Details =::Account SEK" and use the above "if" calculation, the whole FM Crashes.

Mats, your Invoices db needed to be restored twice just to bring it back and it continues to crash on you. It's not that establishing the relationship is wrong, it's that your Invoices db is funky. I've already given you my suggestion ... that you probably have to re-do your Invoices db. You can try deleting any graphics and layouts (one at a time) and re-saving, I guess, and see if you can delete whatever is messed up; but creating the relationship isn't what is causing it to crash on you, I'm afraid. Better to re-do it now than once you've progressed any further. And it's good to know that you now have backup procedures in place.

Back to your Bank Details db ... What do you currently store in this db? You had it previously just holding Account information - each field a different account. Do you now have a ContactsID in it? If so, you could join from Invoice:ContactID to BankDetail::ContactID, but I think you'll still crash.

LaRetta

[Mats]

Hi LaRetta,

No the Bank Details have nothing to do with the Customers as such. The Bank Details have the function to ONLY include my Company's Bank account number for the invoiced currency, as I have a different account for each currency.

I then don't have to wright all the account numbers on the same invoice

[LaRetta]

Hi Mats,

I thought I saw your currency and account details in your Lineitems. Maybe that was your previous structure. Well that makes more sense.

LaRetta

[Mats]

So what shall I do to make it work

/Mats

[LaRetta]

I don't know the answer to that Mats. You need to identify why it keeps crashing on you. I just tried the above calculation in the relationship you specified and it doesn't crash my WinXP! Maybe others can you give you some ideas.

LaRetta

[Ugo DI LUCA]

Corruption to be suspected here I fear...

Try to restore the file.