Focal Point
[SOLVED] AppStudio - Metadata Canvas -> excluding fields from available list

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/5097041196/m/4977015196

August 22, 2019, 12:31 PM
Henry Ma
[SOLVED] AppStudio - Metadata Canvas -> excluding fields from available list
Hi!

I'm creating a Master file and am inserting a "Reference to Existing Synonym" Child Table, but only want to pick certain fields from the Child Table. For example, I don't want the "Surrogate Field" and "Natural Key Field" to be available in the list of fields to pick. How do I do that?

Parent Table
Natural Key Field
Field A
Field B

Child Table fields:
Surrogate Field
Natural Key Field
Field A
Field B

thanks!

This message has been edited. Last edited by: FP Mod Chuck,
August 23, 2019, 09:28 AM
FP Mod Chuck
Henry

Welcome to Focal Point! I think you will find it very helpful for your development questions.

If you edit the child table master and check the INTERNAL box on the fields you don't want to display that should do the trick.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 23, 2019, 09:43 AM
Henry Ma
You are the best Chuck!

thank you!!!