Need Help Designing Pages

drfsupercenter

Hey guys,

I'm posting this question under the Classic Client forum because I need help actually designing the pages, which is done in Object Developer of the classic client.

That being said, here's a quick overview of the functionality we need.
We have a set of "parametric data" parameters that we'd like to add to our item records. There are anywhere from 10 to 50 unique headers, depending on the item category. I've gone ahead and created two tables for this purpose - ID 50002, "Parametric Data", which contains 4 columns:
Code, Applies To, Name, Possible Values. Code is a Length 3 Code field, and using C/AL code I am generating unique letter patterns for each. Starting at AAA and going through ZZZ, that provides over 16,000 possibilities. Applies To is a record link to the Item Category Code field of the Item record.
ID 50003, "PData Responses", which has 3 columns:
Item No., Attribute, Value. Attribute is a length-3 code field which has a record link back to the Code field of 50002.

The way I envision this, it'll be somewhat like Item UoMs, where you can easily create a FactBox or something similar on the item page to show this data.

Here are the things I need help with - and keep in mind I'm a complete beginner, I only just learned how to edit C/AL code at all so if you could please provide as much "how-to" as possible, that would be greatly appreciated.

1. Right now, I made the page over table 50002, in order to access the "name" field of that table. If I did it wrong, I can switch that around. However, I need it to be able to save to 50003, like I mentioned above.
2. I need a way to call this page from the Item page (I found the MSDN tutorial for doing this, no worries there) - but I need the Page to be able to access both the Item No. and the Item Category Code values from the Item page that called the new page. Item No. is for saving the data, Item Category Code is for filtering. See 3:
3. Filtering the rows that show up on the page. Right now, there's almost 1000 rows in table 50002, since there are lots of duplicates - each item category has its own complete set of headers. I assume that if I pass in the value to begin with, I can just use a SETFILTER function in the C/AL code, or something similar.
4. Data entry. I basically need text boxes next to each attribute in the list. However, if there is something specified in "Possible Values", then it should be a drop-down with those choices listed. I also have "[Boolean]" and "[Decimal]" for values that should be of that type. If it's a boolean, maybe a check box? Either way, I need a second column next to the list of attributes that allows someone to enter the data.

I came across this guide, which is what prompted me to register for this forum. It looks like something I could use, but I'm not entirely sure how to implement it.
http://www.mibuso.com/howtoinfo.asp?FileID=9

I know this is possible, but I really don't know how to do it. If anybody can give some pointers, I would really appreciate it!

drfsupercenter

Using the MSDN tutorials, I figured out how to auto-fill the item number when you call it from an item card.

I still can't figure out how to do the rest of this though - essentially if I could display "attribute name" and have the text box for value (I made another form for 50003 to test this), if you could scroll through it for each attribute that would be cool. But the other caveat is that since I made it "create" mode so you can type data in, there's no real way to view that data - and you can't change it save for going in through Classic client and changing it.

--EDIT--

OK, so I managed to change the type to a repeater so it's essentially a list, like I want.

I think what I want is a Rec or xRec but I'm not sure how to use these. What I'd like to do is have it display the "Name" value from table 50002 in that first column. But then when you click OK, it will save the 3-character Code from the same table. Seems like a simple substitution, but I can't access the data from table 50002 since my form is created using 50003.

drfsupercenter

Another update:

I finally learned how to use FlowFields, so I created two of them on table 50003. Attribute Name (Lookup) and Applies To (Lookup).
Both of those are driven by Attribute Code. I can change what triggers that later, if needed.

I also made an "Item Category (Lookup)" that is driven by Item No. Since I call the page using the item card (I already made a Promoted button on the item card form for this), it passes the item number in - automatically stores it in Item No., and as a result, Item Category automatically has the proper value, too. But sadly, not until I hit enter to go to the next line.

Basically, what I'd like to do is have the list only be selectable based on the item category code.

I'd think that now I made a flowfield, it would be a fairly easy filter, "if [item category (lookup)] doesn't equal [passed-in item category value]", but the action is what I can't figure out. I'd basically want it to hide that from the dropdown list you see when you pick the Attribute Code, so the only things you see on that list are driven by category code, does that make sense?
But I don't know how pulldown lists work in RTC, so I need help doing that.

Also, one HUGELY annoying thing is that as soon as I hit enter to go onto the next row, it automatically adds the data! Even if I just click "add parametric data" and close the window right away, it adds a BLANK row (well, blank with the item number), and as a result, when I try to add another one it asks if I want to rename the record.
Is there some way to do a create view, but only have it save when you click OK to the form or close it? I'd figure that hitting ESC would cancel the data creation like it does in nearly everything else in RTC. I tried turning on delayed saving but that didn't help.

Thoughts or ideas, guys? It's been a whole day and I know this is the biggest NAV help site out there... surely someone must have some pointers for me!