How to feed form with a record from a table

Hello guys ,

I searched the forum and found nothing to help me , so
created this new topic ...
I'm working with the component form generator ChronoForms V4
I need to do something simple but STILL could not ...
I'll put here simply to facilitate ...
I have a table : cadastro_empresas

cadastre
------------------
cf_uid
cf_id
cnpj
name
email
User

I managed to create the Database and Save the record in this table
created above ( cadastre ) , but I want to make a consistency ...
OR is, if I type cnpj and he ( record) already exists desire to show ALL
fields of this record , ie , bringing the table ( cadastro_empresas ) ...
I will give a message : Cnpj already registered ( it already did and got ... )
And then immediately have to show ALL fields of the table this record
found in the form ...
I thank you to EVERYONE for your attention and help ... Success to all of JoomlArt ...
PS: I'm trying to use the " DB Record Loader " which is indicated by official Tutorial
in English, but I must have done something wrong , I could not make it work ...

Att ,
Marcos

Hi marcosgomes,

I suggest that you do this as a multi-page form.

On the first page have an input box for the cnpj

On the second page use a DB Record Loader to check for an existing record; if one is found then display the values; if not then show a form or message. You can use the different events in the DB Record Loader to trigger different results.

Bob