I am Navision-screwed.

Design FA Class table. go to the last empty line and click on property. Find the property LookupFormID. set it to the List form that you've created for FA Class. That should do it.

I feel for you, believe me, but you're going to have to learn or not be able to do what you need to do.

Those are pictures of textbox properties. You should be setting the relationship in the table not the form. Remove the TableRelation from the textbox, and remove the LookupFormID as well. The lookup form is handled by the FA Class table, and by setting the tablerelation in the field (in the table, NOT the form) you should automatically get a lookup button in your textbox.

Take a look at form 5600, on the Posting tab. You will see that in design mode there is no lookup button and the table relationship is empty in the textbox property page, as well as the lookup form ID. Now close the Card form and open table 5600, browse down to field number 5 and look at the field properties. Notice that there is a Table Relation, but no lookupformID. Now close table 5600 and open table 5607 in design.

Put your cursor in the first empty line, right underneath the last field. In a standard Cronus database that should be right underneath field 2. Now open the property page, which should now say "Table - Properties" as opposed to "<fieldname> - Properties". Note that the LookupFormID of the TABLE is set to FA Classes.

Now....

Because the FA Class table has a lookup form, every time that Navision gets a command to 'go look up an FA Class record, it will by default open the FA Classes form to display your records, and it will display an OK button so you can select. This is the first part of a working lookup.

Now the second part...
In the Fixed Asset table there is a field called "FA Class Code", with a table relation to the FA Class table. Because this is a table relationship, Navision knowns that you are interested in entering codes that correspond to valid values in the FA Class table, and will deduce from that fact that you will want to be able to look up these values, using the default lookup form.

So.... whenever you put the FA Class Code field on a form, Navision will automatically give you a lookup button (because the field has a table relation. Note that a relation to a table without a lookupformid will also give you a lookup button that won't do anything), and when you click it, it will automatically use the default form to display the records, and you can use the OK button to select one from the list.

Once you get this it is really easy. Once you get used to it you will love that it works that way, at least that's the case for me. I am really happy not to have to program the same friggin lookup stuff for every friggin table. It may be a 'primitive' IDE compared to some other ones out there, but it gets the job done really fast with REALLY little effort, as long as you know what to do.

There, I'll treat myself to a Cuba Libre

ara3n wrote:

Nice screenshot btw. I hope mibuso allows attachment (screenshot).

I believe that insertion of pics has been disabled