Relationship between LOVs and record groups

• All LOVs are based on another Forms object called a record group.
• Record groups are logical objects, so they have no physical properties and are never displayed to the user.
• A record group is similar to a database table in that it stores an array of values in a column and row format.
• Record groups belong to a form and are stored locally on a user’s machine rather that in a database instance.
• The group’s structure can be defined in three ways: by query at design-time, statically at design time, programmatically at run time.
• We can have multiple LOV based on the same record group.
• You should not put a semi colon after the query in the record group.