Default Value from Another Field

[ineedaccesshelp]

I would like to create a Default Value for a field in my DB that uses the another field data as the default entry. Does anyone know how I could do this? Please let me know if further explanation is needed.

[orange]

Further explanation is needed.

[ineedaccesshelp]

So let me make an example. Let's say you have a Fantasy football DB that you are creating multiple forms from. In your first form, you want to just have their basic information, Name, Position and Rookie Team. In the second form, you want to have more detailed information such as their Name, Position, Current Team, Rush, Rec, Pas, YDs, ect...In the second form, you want to make the team default team for the player appear as their rookie team (referenced back to the rookie team field) BUT if you want to change that default entry of their current team, you can without changing the rookie team entry. Do you think you would know how to make this work?

[orange]

You should review Table design and Normalization. Forms are a means to display data for user interaction.Data is stored in Tables. So getting the Table(s) designed properly to support what you are trying to do, is key.

[ineedaccesshelp]

I agree with all of that. However, how do I then get the table to perform this action so that it will display as such on the form? Also, what do you mean by "Normalization"?

[orange]

Please read this article, it has link to Normalization also.
http://forums.aspfree.com/attachment...2&d=1201055452

Good luck with your project.