Member Avatar for dirkjan75

Hi

My db has 2 tables: contactpersons(CP) and companies (COMP) which have a 1 to many relation (1 COMP: many CP). I have build a page for inserting a new CP, one of the fields is a dropdown list for selecting the related COMP.
The case will be that a user will insert a CP before entering the related COMP, so the COMP will not show in the dropdownlist. How can I solve this, without having to move away from the create_CP page and losing all entered data? Can I add a company on the fly?
I work in ASP.net VB, with a (yes) Access DB.

  • 2 Contributors
  • 1 Reply
  • 86 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Pgmer
Member Avatar for Pgmer

Cant you have contact person and company combobox on same page?
if yes then you can validate easily user has selected the company for contact person or not

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.