Could a Lantican or  a user please clarify on the proper syntax to use with this code regarding form!field

A shy forum member had a problem using this code and I volunteered to check it out (they may be sorry I offered to help)

They have a file structure that looks like this

NewSesame
     Forms
           Add Data
                 Customer Data
                       Form1
                       Form2
                 Invoices
                       Inv Data
                 Prod
                       Prod

This worked fine to generate there customer number

If  cusnum = ""  Then
      cusnum = @Tonumber(@XLookupR(@Fn, 999999, "cusnum", "cusnum")) + 1

However this would not work to generate an invoice number

If InvNum = ""  Then
      InvNum = @Tonumber(@XLookupR(@Fn, 999999, "InvNum", "InvNum")) + 1

By adding the form name like this it now works

If InvNum = ""  Then
      InvNum = @Tonumber(@XLookupR(@Fn, 999999, "inv data!InvNum", "InvNum")) + 1

But I can not explain to them how to get the next level to work. We tried

If ProdNum = ""  Then
      InvNum = @Tonumber(@XLookupR(@Fn, 999999, "prodNum", "prodNum")) + 1

and then

If ProdNum = ""  Then
      InvNum = @Tonumber(@XLookupR(@Fn, 999999, "prod!prodNum", "prodNum")) + 1

and then

If ProdNum = ""  Then
      InvNum = @Tonumber(@XLookupR(@Fn, 999999, "prod!prod!prodNum", "prodNum")) + 1

So basically I am asking what is the rule of thumb to follow with this logic and form names. Or were have we gone wrong.

Thanks All.

1

Lousy typing. I was trying to make there form generic before I posted the question because I did not have there permission yet to share it with others and made a typo. in the actual database it is correct.

2

I tried it from the prod form first without success.

3

yes

4

Nothing at all

I have added this type of  layout to my test database and am having the same results. I can get the first 2 branches to work but not the third. But I might be practicing the same mistake. Should the form name followed by the bang then LE be correct?

Thanks

Well I am not sure if this is good or bad thing but before I saw your latest response I deleted the LE and the underlying Field and started over and now it works.

I do not know if it was a typo or something else. I will ask for another copy of  the database that is not working and see if I copy the code from the working one to the non working one what happens.

Sorry. It seems like a ruined the trail back to find the problem.