Custom module, existing schema & relationships

[martinhewitt]

Good morning/afternoon/evening all.

I am close to my wit's end. I have an entity description I wish to create a module for on a SugarCRM implementation. I cannot, for the life of me, work out how to do this. I have followed a fair few tutorials involving various definition files and metadata files, but I cannot seem to "close the loop", i.e. get fields to appear that reference my table.

I have the following:
A table schema and entity description of my new item (a booking)
Two foreign keys (account ID and an exhibition ID)
The table described in a bookings_metadata.php file

I do not have:
My table's fields appearing anywhere in the ModuleBuilder
A way to implement the foreign keys.

I fully accept I might simply be doing things in the wrong order, or be completely off-base. I'm sincerely hoping someone can steer me back onto the right path!

As required, my vital stats are:
Sugar Version 5.0.0RC (Build 2855)
PHP Version 5.2.3
OS Windows Vista
Apache 2.2.4
MySQL version 5.0.45

Thanks,

Martin

[harpic]

Try adding the fields you require with:

dropdown editor

record_type_display

[martinhewitt]

I've been into ModuleBuilder > Module Builder > My Package > My Module > View Fields and added all those for my table in there.

I've also been into I've been into ModuleBuilder > Module Builder > My Package > My Module > View Relationships and added all those for my table in there too.

I've also been into I've been into ModuleBuilder > Module Builder > My Package > My Module > View Layouts and added all those for my module.

However, when I click "deploy", the screen doesn't change, and is overridden by an older version build in "studio", and there seems to be absolutely no crossover whatsoever, studio uses the upper case table names as the field labels instead of the actual label values I specified in Module Builder.

Are Module Builder and Studio supposed to be used together or am I, still, hopelessly lost?

I simply want to achieve the following:
A form that replicates those fields in my database
That form writes to the table
The listing screen shows those rows in the database.

So far I have:
My custom fields entered in Module Builder
Layouts created in Module Builder

Thanks, anyone, for help, even if its only for a small bit of my overall problem!