Microsoft Lightswitch Auto Complete Box 101

Some of the basic ways on how to use the Auto Complete Box of Microsoft Ligthswitch.

1. Auto Complete Box from a foreign key.

This is the most basic way of using the Auto Complete Box.  If you define a foreign key in your table, Microsoft Ligthswich will automatically make that field an Auto Complete Box.

In the above example we define a foreign key in the trnSalesItem table that links to our mstItem.

As you can see Microsoft Lightswitch automatically set the field mstItem as an Auto Complete Box.

2. Auto Complete Box from a local variable or a field with choice list.

The other way of using an Auto Complete Box is to define a local variable or a field with a Choice List.

  • 1. Created a local variable called Month
  • 2. In the property of the local variable I click the Choice List
  • 3. Filled the Choice List with data, in my example, months of the year
  • 4. Automatically Microsoft Lightswitch will make my Month an Auto Complete Box

You can also do this at the EF level, just provide a choice list to any field.

3. Auto complete box from a property.

I use this a lot as filter for my grid.  Remember when you add a local variable you are not limited to just the native variables, e.g., String, int, etc., you can also use the tables (an EF feature).

  • 1. Add a Data Item
  • 2. Choose the Local Property and from the drop down list, choose a Table.  In my example I choose a Sales Representative table.
  • 3. The name of the local variable is Area and its type is the Table mstSalesRepresentative
  • 4. Automatically Microsoft Lightswitch creates an Auto Complete Box for my Area local variable.

These are the most common ways of using an Auto Complete Box in Microsoft Lightswitch, hope you enjoy.

If you find this blog helpful, you can make the donation by clicking the Paypal button below.


Software developer living in the Philippines.

Posted in Lightswitch

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Harold Glenn P. Minerva
Software Developer / Tech Enthusiast
Living in the Philippines

View Harold Glenn Minerva's profile on LinkedIn


Software Engineer - Seasonal and Range Trading Software. Magenta Trader is a powerful stock market visualization software that increases your probability of trading success.

Software Architect and Founder - is a multi-tenant cloud-based Software-as-a-Service (SaaS) business app that caters to micro, small and medium trading businesses.

CTO and Co-Founder - We give your company the leverage by providing innovative software solutions products such as Point-of-Sales (POS), Financial Information System (FMIS), Payroll and DTR (HRIS), and many more.

%d bloggers like this: