I am generating a module from a table. The table has 5 fields. 2 of the fields are lookup values from other tables.
primary table columns:

XRef_VendorRuleSets_UserID
PortalID
ModuleId
CustomerId Lookup from table Customer (CustomerName, CustomerID)
UserID Lookup from table Users (Username, UserID)

When each of the Lookup fields get generated in the "Info" files they are incomplete and generate a compile error. I suspect the code generating the info file is not able to handle the facts the the a column in the primary table has a column with the same name as the value column from the lookup table. Below is some of the code that gets generated (notice the "_").

Private _CustomerName as String
Private _CustomerId as Integer
Private _ as Integer

How should I handle this?