Hi,
I have a form for the computers I have in my home. And another form with a list of computer brands like HP, Apple, Compaq and so…
I want a field in my computer form where I can select one brand from the brands forms and the have it shown in the mail form.
Now, when I link forms I can select “one to many”, “many to many” and join. I think that the one that best fit my needs is join but if I use this what I see is the Id number but not the brand name.
Don’t know how to accomplish this simple task.
Thanks in advance for your help
I’d probably recommend using a pick list for this and setting the “brand” field of your computer form to be that pick list value. It gives you the ability to control the input plus slightly different UI functionality depending on what interaction you want. If you don’t store any extra metadata about the brand (website or logo perhaps) and only want to control the brand list to be consistent then a pick list is probably your best bet.
For the link to form approach I think I’d go for a one to many except I’d link from the brand form into the computers form and tick “show inverse relationship”. That will give you a single entry on the computers form and it will display the fields per the list view settings (by default the first couple of fields). You could do a JOIN but by it’s nature it’s a many to many type so will display a table.
It worked like a charm but in the form it looks tabbed. Can the form aspect be changed?
I’m not sure I follow, do you mind sharing a screenshot of what you’re seeing and what you mean?
Hi Rafael,
That’s where the form’s icon would appear.
Give those child forms an icon and you’ll see them appear there.
Thanks,
Brendan
Cool, I didn’t know that. It looks gorgeous.
Thanks a lot to everyone
Also it’s an easy way to identify your field by the icon.
.
