Jump to content
  • 0

Can I assign a unique identifier to an Imported File database?



Basically, I'm trying to import a file of client information. This client information is hundreds of lines of data.  The information will be re-imported monthly with updated data.

I want to users to create a profile (I've got this), login (I've got this), and then only see data from the imported file unique to them.

When importing the data into the table, I can't seem to "add" a new Unique Identifier that could potentially match the user created profiles.


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi @DougG,

I'm unsure if you meant you want to assign a unique field to the imported data or the table. But if it's the latter, you can set a field as unique in the table using the table design. Just check the Unique checkbox beside the field name on your table. 

If it'll help, here's an article regarding modifying a Table Design:

Modifying a Table's Design

Link to comment
Share on other sites

  • 0

Kronos- to clarify my question:

If importing data into my table, how do I assign a unique identifier so that new users can create an account and only see their specific information in the uploaded table?

Example:  I have name, address, last four of SS#, data 1, data 2, data 3, etc.

If a new user creates an account to view their data from the table, how could I have an identifier that would connect the user and their specific data in the table?  I could use the complete SS# as that would be unique.  However, for compliance purposes, not doing it.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...